APPS.CSC_PROFILE_VARIABLE_PVT dependencies on ALL_TAB_COLUMNS

Line 170: select data_type from sys.all_Tab_columns

166: -- and columns in the diff copies would be same and pick up only
167: -- the first match.
168:
169: cursor datatype is
170: select data_type from sys.all_Tab_columns
171: where table_name = x_table_name
172: and column_name = x_column_name;
173:
174:

Line 184: from sys.all_tab_columns

180: where block_id = p_block_id;
181:
182: Cursor C3 is
183: select count(distinct column_name)
184: from sys.all_tab_columns
185: where table_name = 'CSC_PROF_DRILLDOWN_V'
186: and column_name <> 'ROW_ID';
187:
188: l_count Number := 0;