APPS.CN_SYS_TABLES_PVT dependencies on ALL_TAB_COLUMNS

Line 881: FROM all_tab_columns col, user_synonyms syn

877: AND object_type = 'TBL';
878:
879: CURSOR l_valid_col_csr(p_table_id number) IS
880: SELECT count(*)
881: FROM all_tab_columns col, user_synonyms syn
882: WHERE syn.synonym_name = p_table_name
883: AND col.owner = syn.table_owner
884: AND col.table_name = syn.table_name
885: AND col.column_name = p_column_name

Line 896: FROM all_tab_columns col, user_synonyms syn

892: AND object_type = 'COL');
893:
894: CURSOR l_col_data_csr IS
895: SELECT data_type, data_length
896: FROM all_tab_columns col, user_synonyms syn
897: WHERE syn.synonym_name = p_table_name
898: AND col.owner = syn.table_owner
899: AND col.table_name = syn.table_name
900: AND col.column_name = p_column_name