APPS.PJI_FM_PLAN_MAINT_T_PVT dependencies on PJI_PJP_RBS_HEADER

Line 2616: , pji_pjp_rbs_header rhdr

2612: , pji_time_cal_period_v prd
2613: , PJI_ORG_EXTR_INFO oei
2614: , pji_fp_txn_accum_header hdr
2615: , pa_rbs_txn_accum_map map
2616: , pji_pjp_rbs_header rhdr
2617: WHERE 1=1
2618: AND ra.resource_asSIGNment_id = bl.resource_asSIGNment_id
2619: AND ra.project_id = ver.PROJECT_ID
2620: AND ra.budget_version_id = ver.plan_version_id

Line 2922: , pji_pjp_rbs_header rhdr

2918: -- , pji_time_cal_period prd
2919: -- , PJI_ORG_EXTR_INFO oei
2920: , pji_fp_txn_accum_header hdr
2921: , pa_rbs_txn_accum_map map
2922: , pji_pjp_rbs_header rhdr
2923: WHERE 1=1
2924: AND ra.resource_asSIGNment_id = bl.resource_asSIGNment_id
2925: AND ra.project_id = ver.PROJECT_ID
2926: AND ra.budget_version_id = ver.plan_version_id

Line 8822: , pji_pjp_rbs_header rhdr

8818: , fact1.plan_type_code /* 4471527 */
8819: FROM pji_fp_aggr_pjp1_t fact1
8820: , Pji_RBS_DENORM rbs
8821: , pji_rollup_level_status smart
8822: , pji_pjp_rbs_header rhdr
8823: WHERE 1 = 1
8824: AND fact1.project_id = rhdr.project_id
8825: AND fact1.plan_version_id = rhdr.plan_version_id
8826: AND fact1.plan_type_code = rhdr.plan_type_code /*4471527 */

Line 9083: INSERT INTO pji_pjp_rbs_header

9079: BEGIN
9080:
9081: print_time ( ' Before update rbs header ' );
9082:
9083: INSERT INTO pji_pjp_rbs_header
9084: (
9085: project_id
9086: , plan_version_id
9087: , rbs_version_id

Line 9112: , pji_pjp_rbs_header head

9108: , l_last_update_login
9109: , bv.plan_type_code /*4471527 */
9110: FROM pa_rbs_prj_assignments rpa
9111: , PJI_FM_EXTR_PLNVER3_T bv
9112: , pji_pjp_rbs_header head
9113: WHERE bv.project_id = rpa.project_id
9114: AND bv.RBS_STRUCT_VERSION_ID = rpa.RBS_VERSION_ID
9115: AND bv.PROJECT_ID = head.PROJECT_ID (+)
9116: AND bv.PLAN_VERSION_ID = head.PLAN_VERSION_ID (+)

Line 9124: INSERT INTO pji_pjp_rbs_header

9120: AND bv.plan_version_id > 0;
9121:
9122: print_time ( ' After populate rbs header for WPs/FPs. # rows inserted = ' || SQL%ROWCOUNT );
9123:
9124: INSERT INTO pji_pjp_rbs_header
9125: (
9126: project_id
9127: , plan_version_id
9128: , rbs_version_id

Line 9152: , pji_pjp_rbs_header head

9148: , l_created_by
9149: , l_last_update_login
9150: , bv.plan_type_code /* 4471527 */
9151: FROM PJI_FM_EXTR_PLNVER3_T bv
9152: , pji_pjp_rbs_header head
9153: WHERE bv.PROJECT_ID = head.PROJECT_ID (+)
9154: AND bv.PLAN_VERSION_ID = head.PLAN_VERSION_ID (+)
9155: AND bv.plan_type_code = head.plan_type_code (+) /* 4471527 */
9156: AND bv.RBS_STRUCT_VERSION_ID = head.RBS_VERSION_ID (+)