APPS.BSC_UPDATE_UTIL dependencies on ALL_TAB_COLUMNS

Line 237: FROM all_tab_columns

233: h_drop_it BOOLEAN;
234:
235: CURSOR c_table_columns (p_table_name VARCHAR2, p_owner VARCHAR2) IS
236: SELECT column_name, data_type, data_length, data_precision
237: FROM all_tab_columns
238: WHERE table_name = p_table_name AND owner = p_owner
239: ORDER BY column_id;
240:
241: h_column_name VARCHAR2(30);

Line 264: FROM all_tab_columns

260: -- re-create the temporal table
261:
262: SELECT COUNT(*)
263: INTO h_count
264: FROM all_tab_columns
265: WHERE table_name = x_table_name AND owner = BSC_APPS.BSC_APPS_SCHEMA;
266:
267: IF h_count = 0 THEN
268: -- table does not exists

Line 409: FROM all_tab_columns

405: h_drop_it BOOLEAN;
406:
407: CURSOR c_table_columns (p_table_name VARCHAR2, p_owner VARCHAR2) IS
408: SELECT column_name, data_type, data_length, data_precision
409: FROM all_tab_columns
410: WHERE table_name = p_table_name AND owner = p_owner
411: ORDER BY column_id;
412:
413: h_column_name VARCHAR2(30);

Line 435: FROM all_tab_columns

431: -- re-create the temporal table
432:
433: SELECT COUNT(*)
434: INTO h_count
435: FROM all_tab_columns
436: WHERE table_name = x_table_name AND owner = BSC_APPS.BSC_APPS_SCHEMA;
437:
438: IF h_count = 0 THEN
439: -- table does not exists