APPS.AD_ZD_PREP dependencies on DBA_SYNONYMS

Line 1607: from dba_synonyms syn

1603: select syn.synonym_name ,
1604: syn.table_owner ,
1605: syn.table_name ,
1606: syn.db_link
1607: from dba_synonyms syn
1608: where syn.owner='PUBLIC'
1609: and syn.table_owner in
1610: (select oracle_username
1611: from SYSTEM.fnd_oracle_userid

Line 1665: from dba_synonyms

1661: for l_users in c_depndent_users loop
1662: begin
1663: -- Check if private synonym exists?
1664: select 1 into l_exist
1665: from dba_synonyms
1666: where owner = l_users.owner
1667: and synonym_name = x_synonym_name
1668: and table_owner = x_table_owner
1669: and table_name = x_table_name

Line 1774: from dba_synonyms aps

1770: --
1771: -- Synonyms in CTXSYS for EBS objects.
1772: cursor C_SYNONYMS is
1773: select aps.synonym_name
1774: from dba_synonyms aps
1775: where aps.owner = 'CTXSYS'
1776: and aps.table_owner in
1777: ( select oracle_username
1778: from SYSTEM.fnd_oracle_userid

Line 1853: from dba_synonyms syn

1849: select syn.synonym_name ,
1850: syn.table_owner ,
1851: syn.table_name ,
1852: syn.db_link
1853: from dba_synonyms syn
1854: where syn.owner='PUBLIC'
1855: and syn.table_owner = x_user
1856: and (syn.table_owner, syn.table_name) in
1857: (select obj.owner, obj.object_name