APPS.PJI_FM_XBS_ACCUM_MAINT dependencies on PJI_FP_AGGR_PJP1_T

Line 5713: INSERT INTO pji_fp_aggr_pjp1_t (

5709: --Inserting 'L' 'N' 'N' / 'L' 'N' 'Y' slices
5710: FOR k IN 1..l_rbs_version_id_tbl.COUNT LOOP
5711: FORALL j IN 1..l_plan_version_id_tbl.COUNT
5712:
5713: INSERT INTO pji_fp_aggr_pjp1_t (
5714: WORKER_ID,
5715: PRG_LEVEL,
5716: PROJECT_ID,
5717: PROJECT_ORG_ID,

Line 5890: INSERT INTO pji_fp_aggr_pjp1_t (

5886: end if;
5887:
5888: --WBS rollup for LNN / LNY slices
5889: FORALL j IN 1..l_roll_wbs_version_id_tbl.COUNT
5890: INSERT INTO pji_fp_aggr_pjp1_t (
5891: WORKER_ID,
5892: PRG_LEVEL,
5893: PROJECT_ID,
5894: PROJECT_ORG_ID,

Line 6039: pji_fp_aggr_pjp1_t fact,

6035: SUM(fact.CUSTOM14),
6036: SUM(fact.CUSTOM15),
6037: fact.PLAN_TYPE_CODE /*4471527 */
6038: FROM
6039: pji_fp_aggr_pjp1_t fact,
6040: pji_pjp_wbs_header head,
6041: pji_xbs_denorm xbs
6042: WHERE
6043: xbs.STRUCT_VERSION_ID = head.WBS_VERSION_ID AND

Line 6084: INSERT INTO pji_fp_aggr_pjp1_t (

6080: end if;
6081:
6082: --XBS Rollup for WBS slice
6083: FORALL j IN 1..l_roll_wbs_version_id_tbl.COUNT
6084: INSERT INTO pji_fp_aggr_pjp1_t (
6085: WORKER_ID,
6086: PRG_LEVEL,
6087: PROJECT_ID,
6088: PROJECT_ORG_ID,

Line 6233: pji_fp_aggr_pjp1_t fact,

6229: SUM(fact.CUSTOM14),
6230: SUM(fact.CUSTOM15),
6231: fact.PLAN_TYPE_CODE /*4471527 */
6232: FROM
6233: pji_fp_aggr_pjp1_t fact,
6234: pji_pjp_wbs_header head,
6235: pji_xbs_denorm xbs
6236:
6237: WHERE

Line 6279: INSERT INTO pji_fp_aggr_pjp1_t (

6275: Pji_Utils.write2log(' Inserted XBS rollup for WBS slices ' || SQL%ROWCOUNT ,null,3);
6276: end if;
6277: --RBS Rollup for all slices
6278: FORALL j IN 1..l_rbs_version_id_tbl.COUNT
6279: INSERT INTO pji_fp_aggr_pjp1_t (
6280: WORKER_ID,
6281: PRG_LEVEL,
6282: PROJECT_ID,
6283: PROJECT_ORG_ID,

Line 6428: pji_fp_aggr_pjp1_t fact,

6424: SUM(fact.CUSTOM14),
6425: SUM(fact.CUSTOM15),
6426: fact.PLAN_TYPE_CODE /*4471527 */
6427: FROM
6428: pji_fp_aggr_pjp1_t fact,
6429: pji_rbs_denorm rbs
6430: WHERE
6431: rbs.STRUCT_VERSION_ID = l_rbs_version_id_tbl(j) AND
6432: rbs.SUP_LEVEL <> rbs.SUB_LEVEL AND

Line 6496: DELETE FROM pji_fp_aggr_pjp1_t;

6492: Pji_Pjp_Fp_Curr_Wrap.INIT_ERR_STACK
6493: ( p_package_name => g_package_name
6494: , x_return_status => l_return_status );
6495:
6496: DELETE FROM pji_fp_aggr_pjp1_t;
6497: DELETE FROM PJI_FM_EXTR_PLNVER3_T;
6498: DELETE FROM pji_fp_rmap_fpr_update_t;
6499: EXCEPTION
6500: WHEN OTHERS THEN