APPS.PJI_PROCESS_UTIL dependencies on DBA_INDEXES

Line 517: FROM dba_indexes

513: IF (p_tablename = 'PJI_FP_AGGR_PJP1' OR p_tablename = 'PJI_FP_AGGR_PJP2') THEN -- Added for bug 13897252
514: /* Added for Bug 13813361 Start */
515: FOR ind_lp IN (SELECT table_owner||'.'||index_name ind_name
516: , partitioned
517: FROM dba_indexes
518: WHERE table_name = p_tablename
519: AND table_owner = l_pji_schema) LOOP
520: IF ind_lp.partitioned = 'YES' THEN
521: EXECUTE IMMEDIATE 'ALTER INDEX '||ind_lp.ind_name||' MODIFY PARTITION '||p_partition||' UNUSABLE';

Line 532: FROM dba_indexes

528: 'alter table '||p_schema||'.'||p_tablename||' truncate partition '||p_partition||' drop storage update global indexes';
529:
530: FOR ind_lp IN (SELECT table_owner||'.'||index_name ind_name
531: , partitioned
532: FROM dba_indexes
533: WHERE table_name = p_tablename
534: AND table_owner = l_pji_schema) LOOP
535: IF ind_lp.partitioned = 'YES' THEN
536: EXECUTE IMMEDIATE 'ALTER INDEX '||ind_lp.ind_name||' REBUILD PARTITION '||p_partition;