APPS.PJI_PJP_PRG_PERF_ALL dependencies on PJI_FM_EXTR_PLNVER3_T

Line 5655: INSERT INTO pji_fm_extr_plnver3_t

5651: l_workplan_type_id := NULL;
5652: end;
5653:
5654:
5655: INSERT INTO pji_fm_extr_plnver3_t
5656: (worker_id,project_id,plan_version_id,time_phased_type_code)
5657: select
5658: map.worker_id,bv.project_id,bv.budget_version_id,
5659: nvl(fpo.all_time_phased_code,nvl(fpo.cost_time_phased_code,fpo.revenue_time_phased_code)) time_phased_code

Line 6203: PJI_FM_EXTR_PLNVER3_T map,

6199: - fpr.CUSTOM13 CUSTOM13,
6200: - fpr.CUSTOM14 CUSTOM14,
6201: - fpr.CUSTOM15 CUSTOM15
6202: from
6203: PJI_FM_EXTR_PLNVER3_T map,
6204: PJI_FP_XBS_ACCUM_F fpr
6205: where
6206: l_extraction_type = 'PARTIAL' and
6207: map.WORKER_ID = p_worker_id and

Line 6296: delete from PJI_FM_EXTR_PLNVER3_T where worker_id=p_worker_id;

6292: nvl(sum(CUSTOM14), 0) = 0 and
6293: nvl(sum(CUSTOM15), 0) = 0);
6294:
6295: if ( l_extraction_type = 'PARTIAL' ) then -- Partial Refresh Performance Improvement
6296: delete from PJI_FM_EXTR_PLNVER3_T where worker_id=p_worker_id;
6297: end if;
6298:
6299: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_PJP_SUM_ROLLUP.AGGREGATE_FP_CUST_SLICES(p_worker_id);');
6300: