SYSTEM.AD_INVOKER dependencies on DBA_OBJECTS

Line 44: from dba_objects do, fnd_oracle_userid u

40: and o.mtime >= t.timestamp;
41:
42: cursor GRANTS_NOT_INCR is
43: select do.owner, do.object_name, do.object_type, u.oracle_username
44: from dba_objects do, fnd_oracle_userid u
45: where do.owner =
46: (select o.oracle_username
47: from fnd_oracle_userid o
48: where o.read_only_flag = 'U'

Line 58: from dba_objects do, fnd_oracle_userid u, ad_timestamps t

54: and u.install_group_num > 1;
55:
56: cursor GRANTS_INCR is
57: select do.owner, do.object_name, do.object_type, u.oracle_username
58: from dba_objects do, fnd_oracle_userid u, ad_timestamps t
59: where do.owner =
60: (select o.oracle_username
61: from fnd_oracle_userid o
62: where o.read_only_flag = 'U'

Line 75: from dba_objects do

71: and do.last_ddl_time >= t.timestamp;
72:
73: cursor MRC_GRANTS_OBJ_ID (c_apps_schema in varchar2) is
74: select do.owner, do.object_name, do.object_type
75: from dba_objects do
76: where do.owner = upper(c_apps_schema)
77: and do.object_type in ('PACKAGE', 'PROCEDURE', 'FUNCTION',
78: 'JAVA CLASS')
79: and do.object_name not in ('APPS_DDL', 'APPS_ARRAY_DDL')