APPS.PJI_FM_XBS_ACCUM_UTILS dependencies on PJI_PJP_WBS_HEADER

Line 1733: FROM pji_pjp_wbs_header

1729: if l_pjt_rollup_enabled_flag = 'N' then
1730:
1731: SELECT WBS_VERSION_ID
1732: INTO l_wking_struct_ver_id
1733: FROM pji_pjp_wbs_header
1734: WHERE plan_version_id = p_plan_version_id;
1735: else
1736:
1737: select project_structure_version_id

Line 1771: FROM pji_pjp_wbs_header head,

1767:
1768:
1769: SELECT head.PLAN_VERSION_ID
1770: INTO l_plan_ver_id
1771: FROM pji_pjp_wbs_header head,
1772: pa_budget_versions bv
1773: WHERE 1=1
1774: AND head.plan_version_id = bv.budget_version_id
1775: AND NVL(bv.wp_version_flag, 'N') = head.wp_flag

Line 1833: FROM pji_pjp_wbs_header head,

1829:
1830:
1831: SELECT head.PLAN_VERSION_ID
1832: INTO l_base_plan_ver_id
1833: FROM pji_pjp_wbs_header head,
1834: pa_budget_versions bv
1835: WHERE 1=1
1836: AND head.plan_version_id = bv.budget_version_id
1837: AND NVL(bv.wp_version_flag, 'N') = head.wp_flag

Line 3519: FROM pji_pjp_wbs_header wbs

3515: UPDATE pji_plan_extr_tmp TMP
3516: SET WK_STRUCT_VER_ID=
3517: (
3518: SELECT WBS_VERSION_ID
3519: FROM pji_pjp_wbs_header wbs
3520: WHERE wbs.project_id=tmp.project_id AND
3521: plan_version_id = tmp.plan_ver_id
3522: );
3523:

Line 3529: FROM pji_pjp_wbs_header head,

3525:
3526: UPDATE pji_plan_extr_tmp TMP
3527: SET WK_PLAN_VER_ID= (
3528: SELECT head.PLAN_VERSION_ID
3529: FROM pji_pjp_wbs_header head,
3530: pa_budget_versions bv
3531: WHERE 1=1
3532: AND head.plan_version_id = bv.budget_version_id
3533: AND NVL(bv.wp_version_flag, 'N') = head.wp_flag

Line 3557: FROM pji_pjp_wbs_header head,

3553:
3554: UPDATE pji_plan_extr_tmp TMP
3555: SET BASE_PLAN_VER_ID= (
3556: SELECT head.PLAN_VERSION_ID
3557: FROM pji_pjp_wbs_header head,
3558: pa_budget_versions bv
3559: WHERE 1=1
3560: AND head.plan_version_id = bv.budget_version_id
3561: AND NVL(bv.wp_version_flag, 'N') = head.wp_flag

Line 3718: pji_pjp_wbs_header head

3714: )
3715: )
3716: den,
3717: pa_proj_element_versions ver,
3718: pji_pjp_wbs_header head
3719: WHERE
3720: den.WBS_VERSION_ID = ver.element_version_id AND
3721: den.record_type is not null AND
3722: DECODE(SUBSTR(den.RECORD_TYPE,2,1),'S',1,'R',den.RELATIONSHIP) =1 AND

Line 3784: pji_pjp_wbs_header head

3780: base.struct_version_id is null
3781: )
3782: den,
3783: pa_proj_element_versions ver,
3784: pji_pjp_wbs_header head
3785: WHERE
3786: den.wbs_version_id = ver.element_version_id AND
3787: ver.project_id = head.project_id AND
3788: den.wbs_version_id = head.wbs_version_id AND

Line 4737: FROM pji_pjp_wbs_header

4733: BEGIN
4734:
4735: SELECT wbs_version_id
4736: INTO l_struct_element_id
4737: FROM pji_pjp_wbs_header
4738: WHERE project_id = p_project_id AND plan_version_id=-1;
4739:
4740: l_populate_in_rec.project_id := p_project_id;
4741: l_populate_in_rec.struct_ver_id := l_struct_element_id;