APPS.PJI_FM_XBS_ACCUM_UTILS dependencies on PJI_PJP_WBS_HEADER

Line 1618: FROM pji_pjp_wbs_header

1614: print_time ( ' populate_updatewbs_data 0003.2 ' ) ;
1615:
1616: SELECT WBS_VERSION_ID
1617: INTO l_wking_struct_ver_id
1618: FROM pji_pjp_wbs_header
1619: WHERE plan_version_id = p_plan_version_id;
1620:
1621: EXCEPTION
1622: WHEN NO_DATA_FOUND THEN

Line 1639: FROM pji_pjp_wbs_header head,

1635: print_time ( ' populate_updatewbs_data 0003.4 ' ) ;
1636:
1637: SELECT head.PLAN_VERSION_ID
1638: INTO l_plan_ver_id
1639: FROM pji_pjp_wbs_header head,
1640: pa_budget_versions bv
1641: WHERE 1=1
1642: AND head.plan_version_id = bv.budget_version_id
1643: AND NVL(bv.wp_version_flag, 'N') = head.wp_flag

Line 1673: FROM pji_pjp_wbs_header head,

1669: print_time ( ' populate_updatewbs_data 0003.6 ' ) ;
1670:
1671: SELECT head.PLAN_VERSION_ID
1672: INTO l_base_plan_ver_id
1673: FROM pji_pjp_wbs_header head,
1674: pa_budget_versions bv
1675: WHERE 1=1
1676: AND head.plan_version_id = bv.budget_version_id
1677: AND NVL(bv.wp_version_flag, 'N') = head.wp_flag

Line 2411: FROM pji_pjp_wbs_header wbs

2407: UPDATE pji_plan_extr_tmp TMP
2408: SET WK_STRUCT_VER_ID=
2409: (
2410: SELECT WBS_VERSION_ID
2411: FROM pji_pjp_wbs_header wbs
2412: WHERE wbs.project_id=tmp.project_id AND
2413: plan_version_id = tmp.plan_ver_id
2414: );
2415:

Line 2421: FROM pji_pjp_wbs_header head,

2417:
2418: UPDATE pji_plan_extr_tmp TMP
2419: SET WK_PLAN_VER_ID= (
2420: SELECT head.PLAN_VERSION_ID
2421: FROM pji_pjp_wbs_header head,
2422: pa_budget_versions bv
2423: WHERE 1=1
2424: AND head.plan_version_id = bv.budget_version_id
2425: AND NVL(bv.wp_version_flag, 'N') = head.wp_flag

Line 2449: FROM pji_pjp_wbs_header head,

2445:
2446: UPDATE pji_plan_extr_tmp TMP
2447: SET BASE_PLAN_VER_ID= (
2448: SELECT head.PLAN_VERSION_ID
2449: FROM pji_pjp_wbs_header head,
2450: pa_budget_versions bv
2451: WHERE 1=1
2452: AND head.plan_version_id = bv.budget_version_id
2453: AND NVL(bv.wp_version_flag, 'N') = head.wp_flag

Line 2610: pji_pjp_wbs_header head

2606: )
2607: )
2608: den,
2609: pa_proj_element_versions ver,
2610: pji_pjp_wbs_header head
2611: WHERE
2612: den.WBS_VERSION_ID = ver.element_version_id AND
2613: den.record_type is not null AND
2614: DECODE(SUBSTR(den.RECORD_TYPE,2,1),'S',1,'R',den.RELATIONSHIP) =1 AND

Line 2676: pji_pjp_wbs_header head

2672: base.struct_version_id is null
2673: )
2674: den,
2675: pa_proj_element_versions ver,
2676: pji_pjp_wbs_header head
2677: WHERE
2678: den.wbs_version_id = ver.element_version_id AND
2679: ver.project_id = head.project_id AND
2680: den.wbs_version_id = head.wbs_version_id AND

Line 3595: FROM pji_pjp_wbs_header

3591: BEGIN
3592:
3593: SELECT wbs_version_id
3594: INTO l_struct_element_id
3595: FROM pji_pjp_wbs_header
3596: WHERE project_id = p_project_id AND plan_version_id=-1;
3597:
3598: l_populate_in_rec.project_id := p_project_id;
3599: l_populate_in_rec.struct_ver_id := l_struct_element_id;