APPS.FND_AUDIT_REPORT dependencies on DBA_OBJECTS

Line 100: from dba_objects o

96: and t.table_app_id = a.application_id;
97:
98: cursor c2 (p_table_name varchar2, p_appl_short_name varchar2) is
99: select o.object_name, o.status
100: from dba_objects o
101: where object_name = p_table_name||'_A'
102: and object_type = 'TABLE'
103: and owner = p_appl_short_name;
104:

Line 107: from dba_objects o

103: and owner = p_appl_short_name;
104:
105: cursor c3 (p_table_name varchar2, p_appl_short_name varchar2) is
106: select o.object_name, o.status
107: from dba_objects o
108: where object_name = p_table_name||'_AI'
109: and object_type = 'TRIGGER'
110: and owner = p_appl_short_name;
111:

Line 114: from dba_objects o

110: and owner = p_appl_short_name;
111:
112: cursor c4 (p_table_name varchar2, p_appl_short_name varchar2) is
113: select o.object_name, o.status
114: from dba_objects o
115: where object_name = p_table_name||'_AU'
116: and object_type = 'TRIGGER'
117: and owner = p_appl_short_name;
118:

Line 121: from dba_objects o

117: and owner = p_appl_short_name;
118:
119: cursor c5 (p_table_name varchar2, p_appl_short_name varchar2) is
120: select o.object_name, o.status
121: from dba_objects o
122: where object_name = p_table_name||'_AD'
123: and object_type = 'TRIGGER'
124: and owner = p_appl_short_name;
125:

Line 128: from dba_objects o

124: and owner = p_appl_short_name;
125:
126: cursor c6 (p_table_name varchar2, p_appl_short_name varchar2) is
127: select o.object_name, o.status
128: from dba_objects o
129: where object_name = p_table_name||'_AIP'
130: and object_type = 'PROCEDURE'
131: and owner = p_appl_short_name;
132:

Line 135: from dba_objects o

131: and owner = p_appl_short_name;
132:
133: cursor c7 (p_table_name varchar2, p_appl_short_name varchar2) is
134: select o.object_name, o.status
135: from dba_objects o
136: where object_name = p_table_name||'_AUP'
137: and object_type = 'PROCEDURE'
138: and owner = p_appl_short_name;
139:

Line 142: from dba_objects o

138: and owner = p_appl_short_name;
139:
140: cursor c8 (p_table_name varchar2, p_appl_short_name varchar2) is
141: select o.object_name, o.status
142: from dba_objects o
143: where object_name = p_table_name||'_ADP'
144: and object_type = 'PROCEDURE'
145: and owner = p_appl_short_name;
146:

Line 149: from dba_objects o

145: and owner = p_appl_short_name;
146:
147: cursor c9 (p_table_name varchar2, p_appl_short_name varchar2) is
148: select o.object_name, o.status
149: from dba_objects o
150: where object_name like p_table_name||'_AV%'
151: and object_type = 'VIEW'
152: and owner = p_appl_short_name;
153:

Line 156: from dba_objects o

152: and owner = p_appl_short_name;
153:
154: cursor c10 (p_table_name varchar2, p_appl_short_name varchar2) is
155: select o.object_name, o.status
156: from dba_objects o
157: where object_name like p_table_name||'_AC%'
158: and object_type = 'VIEW'
159: and owner = p_appl_short_name;
160:

Line 200: from dba_objects o

196: select user from dual;
197:
198: cursor c13 (p_table_name varchar2, p_appl_short_name varchar2) is
199: select o.object_name, o.status
200: from dba_objects o
201: where object_name = p_table_name
202: and object_type = 'TABLE'
203: and owner = p_appl_short_name;
204:

Line 207: from dba_objects o

203: and owner = p_appl_short_name;
204:
205: cursor c14 (p_table_name varchar2, p_appl_short_name varchar2) is
206: select o.object_name, o.status
207: from dba_objects o
208: where object_name = p_table_name
209: and owner = p_appl_short_name
210: and object_type = 'SYNONYM';
211:

Line 214: from dba_objects o

210: and object_type = 'SYNONYM';
211:
212: cursor c15 (p_table_name varchar2, p_appl_short_name varchar2) is
213: select o.object_name, o.status
214: from dba_objects o
215: where object_name = p_table_name||'_A'
216: and owner = p_appl_short_name
217: and object_type = 'SYNONYM';
218: