APPS.PJI_FM_PLAN_MAINT_T_PVT dependencies on PJI_PJP_RBS_HEADER

Line 2549: , pji_pjp_rbs_header rhdr

2545: , pji_time_cal_period_v prd
2546: , PJI_ORG_EXTR_INFO oei
2547: , pji_fp_txn_accum_header hdr
2548: , pa_rbs_txn_accum_map map
2549: , pji_pjp_rbs_header rhdr
2550: WHERE 1=1
2551: AND ra.resource_asSIGNment_id = bl.resource_asSIGNment_id
2552: AND ra.project_id = ver.PROJECT_ID
2553: AND ra.budget_version_id = ver.plan_version_id

Line 2852: , pji_pjp_rbs_header rhdr

2848: -- , pji_time_cal_period prd
2849: -- , PJI_ORG_EXTR_INFO oei
2850: , pji_fp_txn_accum_header hdr
2851: , pa_rbs_txn_accum_map map
2852: , pji_pjp_rbs_header rhdr
2853: WHERE 1=1
2854: AND ra.resource_asSIGNment_id = bl.resource_asSIGNment_id
2855: AND ra.project_id = ver.PROJECT_ID
2856: AND ra.budget_version_id = ver.plan_version_id

Line 8674: , pji_pjp_rbs_header rhdr

8670: , fact1.plan_type_code /* 4471527 */
8671: FROM pji_fp_aggr_pjp1_t fact1
8672: , Pji_RBS_DENORM rbs
8673: , pji_rollup_level_status smart
8674: , pji_pjp_rbs_header rhdr
8675: WHERE 1 = 1
8676: AND fact1.project_id = rhdr.project_id
8677: AND fact1.plan_version_id = rhdr.plan_version_id
8678: AND fact1.plan_type_code = rhdr.plan_type_code /*4471527 */

Line 8935: INSERT INTO pji_pjp_rbs_header

8931: BEGIN
8932:
8933: print_time ( ' Before update rbs header ' );
8934:
8935: INSERT INTO pji_pjp_rbs_header
8936: (
8937: project_id
8938: , plan_version_id
8939: , rbs_version_id

Line 8964: , pji_pjp_rbs_header head

8960: , l_last_update_login
8961: , bv.plan_type_code /*4471527 */
8962: FROM pa_rbs_prj_assignments rpa
8963: , PJI_FM_EXTR_PLNVER3_T bv
8964: , pji_pjp_rbs_header head
8965: WHERE bv.project_id = rpa.project_id
8966: AND bv.RBS_STRUCT_VERSION_ID = rpa.RBS_VERSION_ID
8967: AND bv.PROJECT_ID = head.PROJECT_ID (+)
8968: AND bv.PLAN_VERSION_ID = head.PLAN_VERSION_ID (+)

Line 8976: INSERT INTO pji_pjp_rbs_header

8972: AND bv.plan_version_id > 0;
8973:
8974: print_time ( ' After populate rbs header for WPs/FPs. # rows inserted = ' || SQL%ROWCOUNT );
8975:
8976: INSERT INTO pji_pjp_rbs_header
8977: (
8978: project_id
8979: , plan_version_id
8980: , rbs_version_id

Line 9004: , pji_pjp_rbs_header head

9000: , l_created_by
9001: , l_last_update_login
9002: , bv.plan_type_code /* 4471527 */
9003: FROM PJI_FM_EXTR_PLNVER3_T bv
9004: , pji_pjp_rbs_header head
9005: WHERE bv.PROJECT_ID = head.PROJECT_ID (+)
9006: AND bv.PLAN_VERSION_ID = head.PLAN_VERSION_ID (+)
9007: AND bv.plan_type_code = head.plan_type_code (+) /* 4471527 */
9008: AND bv.RBS_STRUCT_VERSION_ID = head.RBS_VERSION_ID (+)