How can one see if somebody modified any code.

Also, If scott has created the Procedure p1 which inserts the data into table t1 which is created in scott schema.if the scott gives the execute permission on produre p1 to denis(another user),denis also created the table t1 in his shema.when the denis execute the p1 in which user table will populate the data.