APPS.PJI_FM_XBS_ACCUM_MAINT dependencies on PJI_FP_AGGR_PJP1_T

Line 6233: INSERT INTO pji_fp_aggr_pjp1_t (

6229: --Inserting 'L' 'N' 'N' / 'L' 'N' 'Y' slices
6230: FOR k IN 1..l_rbs_version_id_tbl.COUNT LOOP
6231: FORALL j IN 1..l_plan_version_id_tbl.COUNT
6232:
6233: INSERT INTO pji_fp_aggr_pjp1_t (
6234: WORKER_ID,
6235: PRG_LEVEL,
6236: PROJECT_ID,
6237: PROJECT_ORG_ID,

Line 6410: INSERT INTO pji_fp_aggr_pjp1_t (

6406: end if;
6407:
6408: --WBS rollup for LNN / LNY slices
6409: FORALL j IN 1..l_roll_wbs_version_id_tbl.COUNT
6410: INSERT INTO pji_fp_aggr_pjp1_t (
6411: WORKER_ID,
6412: PRG_LEVEL,
6413: PROJECT_ID,
6414: PROJECT_ORG_ID,

Line 6559: pji_fp_aggr_pjp1_t fact,

6555: SUM(fact.CUSTOM14),
6556: SUM(fact.CUSTOM15),
6557: fact.PLAN_TYPE_CODE /*4471527 */
6558: FROM
6559: pji_fp_aggr_pjp1_t fact,
6560: pji_pjp_wbs_header head,
6561: pji_xbs_denorm xbs
6562: WHERE
6563: xbs.STRUCT_VERSION_ID = head.WBS_VERSION_ID AND

Line 6604: INSERT INTO pji_fp_aggr_pjp1_t (

6600: end if;
6601:
6602: --XBS Rollup for WBS slice
6603: FORALL j IN 1..l_roll_wbs_version_id_tbl.COUNT
6604: INSERT INTO pji_fp_aggr_pjp1_t (
6605: WORKER_ID,
6606: PRG_LEVEL,
6607: PROJECT_ID,
6608: PROJECT_ORG_ID,

Line 6753: pji_fp_aggr_pjp1_t fact,

6749: SUM(fact.CUSTOM14),
6750: SUM(fact.CUSTOM15),
6751: fact.PLAN_TYPE_CODE /*4471527 */
6752: FROM
6753: pji_fp_aggr_pjp1_t fact,
6754: pji_pjp_wbs_header head,
6755: pji_xbs_denorm xbs
6756:
6757: WHERE

Line 6799: INSERT INTO pji_fp_aggr_pjp1_t (

6795: Pji_Utils.write2log(' Inserted XBS rollup for WBS slices ' || SQL%ROWCOUNT ,null,3);
6796: end if;
6797: --RBS Rollup for all slices
6798: FORALL j IN 1..l_rbs_version_id_tbl.COUNT
6799: INSERT INTO pji_fp_aggr_pjp1_t (
6800: WORKER_ID,
6801: PRG_LEVEL,
6802: PROJECT_ID,
6803: PROJECT_ORG_ID,

Line 6948: pji_fp_aggr_pjp1_t fact,

6944: SUM(fact.CUSTOM14),
6945: SUM(fact.CUSTOM15),
6946: fact.PLAN_TYPE_CODE /*4471527 */
6947: FROM
6948: pji_fp_aggr_pjp1_t fact,
6949: pji_rbs_denorm rbs
6950: WHERE
6951: rbs.STRUCT_VERSION_ID = l_rbs_version_id_tbl(j) AND
6952: rbs.SUP_LEVEL <> rbs.SUB_LEVEL AND

Line 7016: DELETE FROM pji_fp_aggr_pjp1_t;

7012: Pji_Pjp_Fp_Curr_Wrap.INIT_ERR_STACK
7013: ( p_package_name => g_package_name
7014: , x_return_status => l_return_status );
7015:
7016: DELETE FROM pji_fp_aggr_pjp1_t;
7017: DELETE FROM PJI_FM_EXTR_PLNVER3_T;
7018: DELETE FROM pji_fp_rmap_fpr_update_t;
7019: EXCEPTION
7020: WHEN OTHERS THEN