APPS.CS_SR_SYNC_INDEX_PKG dependencies on DBA_INDEXES

Line 43: SELECT COUNT(*) FROM dba_indexes

39: l_parallel_cmd VARCHAR2(100);
40:
41: CURSOR get_index_cursor(p_index_name VARCHAR2,
42: p_owner VARCHAR2) IS
43: SELECT COUNT(*) FROM dba_indexes
44: WHERE index_name = UPPER(p_index_name)
45: AND owner= UPPER(p_owner);
46:
47: l_total NUMBER := 0;

Line 639: SELECT COUNT(*) FROM dba_indexes

635: IS
636: drop_index VARCHAR2(100) := NULL;
637:
638: CURSOR get_index_cursor(p_index_name VARCHAR2, p_owner VARCHAR2) IS
639: SELECT COUNT(*) FROM dba_indexes
640: WHERE index_name = UPPER(p_index_name)
641: AND owner= UPPER(p_owner);
642: l_total NUMBER := 0;
643: