APPS.PJI_PJP_SUM_MAIN dependencies on PJI_ROLLUP_LEVEL_STATUS

Line 1129: DELETE pji_rollup_level_status hdr

1125: -- pji_utils.write2log('Inserted -3,-4 records into ver4'||sql%rowcount);
1126: -- Delete all the -3,-4 lines from the pji_fp_xbs_accum_f for Cost and Rev plan type having plan type code is null
1127: -- l_Stage := ' Delete all the -3,-4 lines from the pji_fp_xbs_accum_f for Cost and Rev plan type';
1128:
1129: DELETE pji_rollup_level_status hdr
1130: where hdr.plan_version_id < -1
1131: and exists (select 1 from pji_fm_extr_plnver4 ver3
1132: where ver3.worker_id = p_worker_id
1133: and ver3.project_id = hdr.project_id