APPS.AD_OBSOLETE_PRODUCTS dependencies on FND_APPLICATION

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 494: from FND_APPLICATION

490:
491: begin
492: select APPLICATION_SHORT_NAME
493: into l_app_short_name
494: from FND_APPLICATION
495: where APPLICATION_ID = x_appl_id;
496:
497: exception
498: when no_data_found then

Line 501: ||'" is not registered in FND_APPLICATION. ');

497: exception
498: when no_data_found then
499: raise_application_error(-20001,
500: 'Application ID "'|| x_appl_id
501: ||'" is not registered in FND_APPLICATION. ');
502:
503: end;
504:
505: -- Verify if a shared base schema for multiple products