DBA Data[Home] [Help]

SYSTEM.AD_CLONE_UTILS dependencies on DBA_SYNONYMS

Line 847: from dba_synonyms

843:
844: procedure cleanup_chkfile_info(X_apps_schema in varchar2) is
845: cursor c_syn is
846: select synonym_name, table_name, table_owner
847: from dba_synonyms
848: where owner = X_apps_schema
849: and synonym_name = 'AD_PREPMODE_CHECK_FILES';
850: begin
851:

Line 1266: from dba_synonyms src

1262: l_owntab t_objname;
1263:
1264: cursor c_syn is
1265: select synonym_name, table_name, table_owner
1266: from dba_synonyms src
1267: where src.owner = X_source_schema
1268: and src.synonym_name in (
1269: select cl.synonym_name
1270: from dba_synonyms cl

Line 1270: from dba_synonyms cl

1266: from dba_synonyms src
1267: where src.owner = X_source_schema
1268: and src.synonym_name in (
1269: select cl.synonym_name
1270: from dba_synonyms cl
1271: where cl.owner = X_clone_schema
1272: and cl.table_owner = X_spec_schema);
1273:
1274: begin