DBA Data[Home] [Help]

APPS.FA_ASSET_TRACE_PVT dependencies on DBA_TAB_COLUMNS

Line 894: FROM dba_tab_columns col,

890:
891: IF p_schema <> 'NONE' THEN
892: SELECT count(*)
893: INTO l_both
894: FROM dba_tab_columns col,
895: user_synonyms syn
896: WHERE syn.synonym_name = p_table
897: AND col.owner = syn.table_owner
898: AND col.table_name = syn.table_name

Line 909: FROM dba_tab_columns col,

905: ELSE
906:
907: SELECT count(*)
908: INTO l_secondary
909: FROM dba_tab_columns col,
910: user_synonyms syn
911: WHERE syn.synonym_name = p_table
912: AND col.owner = syn.table_owner
913: AND col.table_name = syn.table_name