APPS.CSC_PROFILE_VARIABLE_PVT dependencies on ALL_TAB_COLUMNS

Line 167: from sys.all_Tab_columns

163: -- the first match.
164:
165: cursor datatype is
166: select data_type
167: from sys.all_Tab_columns
168: where table_name = x_table_name
169: and column_name = x_column_name;
170:
171:

Line 181: from sys.all_tab_columns

177: where block_id = p_block_id;
178:
179: Cursor C3 is
180: select count(distinct column_name)
181: from sys.all_tab_columns
182: where table_name = 'CSC_PROF_DRILLDOWN_V'
183: and column_name <> 'ROW_ID';
184:
185: CURSOR VIEW_CHECK IS

Line 192: FROM ALL_TAB_COLUMNS col,

188: WHERE OBJECT_NAME = x_table_name
189: AND OBJECT_TYPE = 'VIEW';
190: CURSOR DATA_TYPE_CUR IS
191: SELECT col.data_type
192: FROM ALL_TAB_COLUMNS col,
193: USER_SYNONYMS SYN
194: WHERE syn.synonym_name = x_table_name
195: AND col.owner = syn.table_owner
196: AND col.table_name = syn.table_name

Line 370: from sys.all_Tab_columns

366: v_data_type varchar2(100);
367:
368: cursor datatype is
369: select data_type
370: from sys.all_Tab_columns
371: where table_name = x_table_name
372: and column_name = x_column_name;
373: Cursor C2 is
374: select where_clause,

Line 381: from sys.all_tab_columns

377: where block_id = p_block_id;
378:
379: Cursor C3 is
380: select count(distinct column_name)
381: from sys.all_tab_columns
382: where table_name = 'CSC_PROF_DRILLDOWN_V'
383: and column_name <> 'ROW_ID';
384:
385: CURSOR VIEW_CHECK IS

Line 392: FROM ALL_TAB_COLUMNS col,

388: WHERE OBJECT_NAME = x_table_name
389: AND OBJECT_TYPE = 'VIEW';
390: CURSOR DATA_TYPE_CUR IS
391: SELECT col.data_type
392: FROM ALL_TAB_COLUMNS col,
393: USER_SYNONYMS SYN
394: WHERE syn.synonym_name = x_table_name
395: AND col.owner = syn.table_owner
396: AND col.table_name = syn.table_name