APPS.AD_OBSOLETE_PRODUCTS dependencies on DBA_SYNONYMS

Line 168: TYPE ds_obj_name IS TABLE OF dba_synonyms.synonym_name%TYPE;

164:
165:
166: procedure drop_synonym_all (x_appl_id in number,
167: x_app_short_name in varchar2) is
168: TYPE ds_obj_name IS TABLE OF dba_synonyms.synonym_name%TYPE;
169: TYPE obs_obj_type IS TABLE OF AD_OBSOLETE_OBJECTS.object_type%TYPE;
170: TYPE obs_obj_name IS TABLE OF AD_OBSOLETE_OBJECTS.object_name%TYPE;
171:
172: ds_object_name ds_obj_name;

Line 215: from dba_synonyms

211: -- get the list of all
212:
213: select synonym_name
214: bulk collect into ds_object_name
215: from dba_synonyms
216: where TABLE_OWNER = l_schema_name
217: and synonym_name not in
218: (select object_name
219: from AD_OBSOLETE_OBJECTS