DBA Data[Home] [Help]

APPS.IBC_CONTENT_SYNC_INDEX_PKG dependencies on DBA_INDEXES

Line 265: SELECT COUNT(*) FROM dba_indexes

261: IS
262: drop_index VARCHAR2(100) := NULL;
263:
264: CURSOR get_index_cursor(p_index_name VARCHAR2, p_owner VARCHAR2) IS
265: SELECT COUNT(*) FROM dba_indexes
266: WHERE index_name = UPPER(p_index_name)
267: AND owner= UPPER(p_owner);
268: l_total NUMBER := 0;
269: