APPS.PJI_PJP_SUM_ROLLUP dependencies on PJI_FM_EXTR_PLNVER3_T

Line 5202: INSERT INTO pji_fm_extr_plnver3_t

5198: l_workplan_type_id := NULL;
5199: end;
5200:
5201:
5202: INSERT INTO pji_fm_extr_plnver3_t
5203: (worker_id,project_id,plan_version_id,time_phased_type_code)
5204: select
5205: map.worker_id,bv.project_id,bv.budget_version_id,
5206: nvl(fpo.all_time_phased_code,nvl(fpo.cost_time_phased_code,fpo.revenue_time_phased_code)) time_phased_code

Line 5750: PJI_FM_EXTR_PLNVER3_T map,

5746: - fpr.CUSTOM13 CUSTOM13,
5747: - fpr.CUSTOM14 CUSTOM14,
5748: - fpr.CUSTOM15 CUSTOM15
5749: from
5750: PJI_FM_EXTR_PLNVER3_T map,
5751: PJI_FP_XBS_ACCUM_F fpr
5752: where
5753: l_extraction_type = 'PARTIAL' and
5754: map.WORKER_ID = p_worker_id and

Line 5843: delete from PJI_FM_EXTR_PLNVER3_T where worker_id=p_worker_id;

5839: nvl(sum(CUSTOM14), 0) = 0 and
5840: nvl(sum(CUSTOM15), 0) = 0);
5841:
5842: if ( l_extraction_type = 'PARTIAL' ) then -- Partial Refresh Performance Improvement
5843: delete from PJI_FM_EXTR_PLNVER3_T where worker_id=p_worker_id;
5844: end if;
5845:
5846: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_PJP_SUM_ROLLUP.AGGREGATE_FP_CUST_SLICES(p_worker_id);');
5847:

Line 9041: PJI_FM_EXTR_PLNVER3_T ver3,

9037: nvl(max(den.SUP_LEVEL), 0)
9038: into
9039: l_level
9040: from
9041: PJI_FM_EXTR_PLNVER3_T ver3,
9042: PJI_XBS_DENORM den
9043: where
9044: den.STRUCT_TYPE = 'PRG' and
9045: den.SUB_LEVEL = den.SUP_LEVEL and

Line 12772: PJI_FM_EXTR_PLNVER3_T ver3,

12768: nvl(max(den.SUP_LEVEL), 0)
12769: into
12770: l_level
12771: from
12772: PJI_FM_EXTR_PLNVER3_T ver3,
12773: PJI_XBS_DENORM den
12774: where
12775: den.STRUCT_TYPE = 'PRG' and
12776: den.SUB_LEVEL = den.SUP_LEVEL and