APPS.AD_OBSOLETE_PRODUCTS dependencies on DBA_OBJECTS

Line 266: from DBA_OBJECTS DO, FND_APPLICATION fa

262: -- Do a bulk collect
263:
264: select object_name,object_type
265: bulk collect into obs_object_name, obs_object_type
266: from DBA_OBJECTS DO, FND_APPLICATION fa
267: where fa.APPLICATION_ID = x_appl_id
268: --and fa.APPLICATION_SHORT_NAME = do.OWNER
269: and do.OWNER = decode (fa.APPLICATION_SHORT_NAME,
270: 'SQLGL', 'GL',

Line 400: (select do.object_name from dba_objects do

396: where aoo.APPLICATION_ID = x_appl_id
397: and (UPPER(dropped) = 'N' or upper(dropped) is null)
398: and aoo.object_type <> 'SYNONYM'
399: and exists
400: (select do.object_name from dba_objects do
401: where do.owner = l_apps_oracle_name
402: and do.OBJECT_NAME = aoo.OBJECT_NAME
403: and do.object_type = aoo.object_type);
404: