DBA Data[Home] [Help]

APPS.BSC_UPDATE_UTIL dependencies on USER_INDEXES

Line 150: FROM user_indexes

146: TYPE t_cursor IS REF CURSOR;
147:
148: CURSOR c_index (p_index_name VARCHAR2) IS
149: SELECT index_name
150: FROM user_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

Line 615: ' FROM user_indexes'||

611:
612: /*
613: c_index t_cursor; -- x_index_name
614: c_index_sql VARCHAR2(2000) := 'SELECT index_name'||
615: ' FROM user_indexes'||
616: ' WHERE index_name = :1';
617: */
618: CURSOR c_index (p_index_name VARCHAR2) IS
619: SELECT index_name

Line 620: FROM user_indexes

616: ' WHERE index_name = :1';
617: */
618: CURSOR c_index (p_index_name VARCHAR2) IS
619: SELECT index_name
620: FROM user_indexes
621: WHERE index_name = p_index_name;
622:
623: /*
624: c_index_apps t_cursor; -- x_index_name, BSC_APPS.BSC_APPS_SCHEMA