APPS.FND_AUDIT_REPORT dependencies on DBA_OBJECTS

Line 101: from dba_objects o

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

Line 108: from dba_objects o

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

Line 115: from dba_objects o

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

Line 122: from dba_objects o

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

Line 129: from dba_objects o

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

Line 136: from dba_objects o

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

Line 143: from dba_objects o

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

Line 150: from dba_objects o

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

Line 157: from dba_objects o

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

Line 203: from dba_objects o

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

Line 210: from dba_objects o

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

Line 217: from dba_objects o

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