APPS.PJI_PJP_SUM_MAIN dependencies on PJI_ROLLUP_LEVEL_STATUS

Line 1152: DELETE pji_rollup_level_status hdr

1148: -- pji_utils.write2log('Inserted -3,-4 records into ver4'||sql%rowcount);
1149: -- 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
1150: -- l_Stage := ' Delete all the -3,-4 lines from the pji_fp_xbs_accum_f for Cost and Rev plan type';
1151:
1152: DELETE pji_rollup_level_status hdr
1153: where hdr.plan_version_id < -1
1154: and exists (select 1 from pji_fm_extr_plnver4 ver3
1155: where ver3.worker_id = p_worker_id
1156: and ver3.project_id = hdr.project_id