APPS.PJI_PJP_SUM_ROLLUP dependencies on PJI_FM_EXTR_PLNVER3_T

Line 8480: INSERT INTO pji_fm_extr_plnver3_t

8476: l_workplan_type_id := NULL;
8477: end;
8478:
8479:
8480: INSERT INTO pji_fm_extr_plnver3_t
8481: (worker_id,project_id,plan_version_id,time_phased_type_code)
8482: select
8483: map.worker_id,bv.project_id,bv.budget_version_id,
8484: nvl(fpo.all_time_phased_code,nvl(fpo.cost_time_phased_code,fpo.revenue_time_phased_code)) time_phased_code

Line 9028: PJI_FM_EXTR_PLNVER3_T map,

9024: - fpr.CUSTOM13 CUSTOM13,
9025: - fpr.CUSTOM14 CUSTOM14,
9026: - fpr.CUSTOM15 CUSTOM15
9027: from
9028: PJI_FM_EXTR_PLNVER3_T map,
9029: PJI_FP_XBS_ACCUM_F fpr
9030: where
9031: l_extraction_type = 'PARTIAL' and
9032: map.WORKER_ID = p_worker_id and

Line 9121: delete from PJI_FM_EXTR_PLNVER3_T where worker_id=p_worker_id;

9117: nvl(sum(CUSTOM14), 0) = 0 and
9118: nvl(sum(CUSTOM15), 0) = 0);
9119:
9120: if ( l_extraction_type = 'PARTIAL' ) then -- Partial Refresh Performance Improvement
9121: delete from PJI_FM_EXTR_PLNVER3_T where worker_id=p_worker_id;
9122: end if;
9123:
9124: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_PJP_SUM_ROLLUP.AGGREGATE_FP_CUST_SLICES(p_worker_id);');
9125:

Line 11154: PJI_FM_EXTR_PLNVER3_T ver3,

11150: nvl(max(den.SUP_LEVEL), 0)
11151: into
11152: l_level
11153: from
11154: PJI_FM_EXTR_PLNVER3_T ver3,
11155: PJI_XBS_DENORM den
11156: where
11157: den.STRUCT_TYPE = 'PRG' and
11158: den.SUB_LEVEL = den.SUP_LEVEL and

Line 14892: PJI_FM_EXTR_PLNVER3_T ver3,

14888: nvl(max(den.SUP_LEVEL), 0)
14889: into
14890: l_level
14891: from
14892: PJI_FM_EXTR_PLNVER3_T ver3,
14893: PJI_XBS_DENORM den
14894: where
14895: den.STRUCT_TYPE = 'PRG' and
14896: den.SUB_LEVEL = den.SUP_LEVEL and