DBA Data[Home] [Help]

APPS.FA_ASSET_TRACE_PVT dependencies on DBA_TAB_COLUMNS

Line 882: FROM dba_tab_columns

878:
879: IF p_schema <> 'NONE' THEN
880: SELECT count(*)
881: INTO l_both
882: FROM dba_tab_columns
883: WHERE column_name IN (l_primary_column,l_secondary_column)
884: AND owner = p_schema
885: AND table_name = p_table;
886: END IF;

Line 895: FROM dba_tab_columns

891: ELSE
892:
893: SELECT count(*)
894: INTO l_secondary
895: FROM dba_tab_columns
896: WHERE column_name = l_secondary_column
897: AND owner = p_schema
898: AND table_name = p_table;
899: