SYSTEM.AD_APPS_PRIVATE dependencies on DBA_SYNONYMS

Line 290: FROM dba_synonyms

286: IF (l_object_type = 'SYNONYM') THEN
287: BEGIN
288: SELECT table_owner
289: INTO l_owner_schema_name
290: FROM dba_synonyms
291: WHERE owner = p_grantor_schema_name
292: AND synonym_name = p_object_name;
293: EXCEPTION
294: WHEN OTHERS THEN

Line 1598: from dba_synonyms ds

1594: where owner= upper(base_schema)
1595: and queue_table not like '%$%')
1596: minus
1597: select ds.synonym_name object_name, 'TABLE ' object_type
1598: from dba_synonyms ds
1599: where ds.owner = upper(apps_schema)
1600: and ds.table_owner = upper(base_schema)
1601: and ds.synonym_name = ds.table_name
1602: and ds.table_name not like '%$%'

Line 1610: from dba_synonyms ds

1606: where sequence_owner= upper(base_schema)
1607: and sequence_name not like '%$%'
1608: minus
1609: select ds.synonym_name object_name, 'SEQUENCE' object_type
1610: from dba_synonyms ds
1611: where ds.owner = upper(apps_schema)
1612: and ds.table_owner = upper(base_schema)
1613: and ds.synonym_name = ds.table_name
1614: and ds.table_name not like '%$%';

Line 1875: from dba_synonyms ds

1871: grant_from_schema in varchar2 default null)
1872: is
1873: cursor c1 is
1874: select ds.synonym_name
1875: from dba_synonyms ds
1876: where ds.owner = upper(from_schema)
1877: and ds.synonym_name = ds.table_name -- regular synonyms only
1878: and ds.synonym_name not like '%$%';
1879: exact_syn_match boolean;

Line 1967: from dba_synonyms ds

1963: toschema in varchar2)
1964: is
1965: cursor c1 is
1966: select ds.synonym_name
1967: from dba_synonyms ds
1968: where ds.owner = upper(fromschema)
1969: and ds.synonym_name <> ds.table_name; -- odd synonyms only
1970: exact_syn_match boolean;
1971: any_obj_w_this_name boolean;

Line 2586: from dba_synonyms

2582: c_synonym_name in varchar2,
2583: c_table_owner in varchar2,
2584: c_table_name in varchar2) is
2585: select 'X'
2586: from dba_synonyms
2587: where owner = c_owner
2588: and synonym_name = c_synonym_name
2589: and table_owner = c_table_owner
2590: and table_name = c_table_name