APPS.BSC_UPDATE_UTIL dependencies on ALL_INDEXES

Line 155: FROM all_indexes

151: WHERE index_name = p_index_name;
152:
153: CURSOR c_index_apps (p_index_name VARCHAR2, p_owner VARCHAR2) IS
154: SELECT index_name
155: FROM all_indexes
156: WHERE index_name = p_index_name AND owner = p_owner;
157:
158: h_index VARCHAR2(30);
159: h_do_it BOOLEAN;

Line 367: FROM all_indexes

363: h_index_name := x_table_name||'_N1';
364:
365: SELECT COUNT(*)
366: INTO h_count
367: FROM all_indexes
368: WHERE index_name = h_index_name AND owner = BSC_APPS.BSC_APPS_SCHEMA;
369:
370: IF h_count > 0 THEN
371: -- Index exist but it is not needed

Line 626: ' FROM all_indexes'||

622:
623: /*
624: c_index_apps t_cursor; -- x_index_name, BSC_APPS.BSC_APPS_SCHEMA
625: c_index_apps_sql VARCHAR2(2000) := 'SELECT index_name'||
626: ' FROM all_indexes'||
627: ' WHERE index_name = :1 AND owner = :2';
628: */
629: CURSOR c_index_apps (p_index_name VARCHAR2, p_owner VARCHAR2) IS
630: SELECT index_name

Line 631: FROM all_indexes

627: ' WHERE index_name = :1 AND owner = :2';
628: */
629: CURSOR c_index_apps (p_index_name VARCHAR2, p_owner VARCHAR2) IS
630: SELECT index_name
631: FROM all_indexes
632: WHERE index_name = p_index_name AND owner = p_owner;
633:
634: h_index VARCHAR2(30);
635: h_do_it BOOLEAN;