APPS.PJI_FM_XBS_ACCUM_UTILS dependencies on PA_BUDGET_VERSIONS

Line 1589: FROM PA_BUDGET_VERSIONS

1585:
1586: BEGIN
1587: SELECT budget_version_id
1588: INTO l_lpb_plan_ver_id
1589: FROM PA_BUDGET_VERSIONS
1590: WHERE project_structure_Version_id = l_lpb_struct_ver_id
1591: AND wp_version_flag ='Y'
1592: AND project_id = p_project_id;
1593:

Line 1640: pa_budget_versions bv

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
1644: AND NVL(bv.wp_version_flag, 'N') = p_workplan_flag

Line 1674: pa_budget_versions bv

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
1678: AND NVL(bv.wp_version_flag, 'N') = p_workplan_flag

Line 2391: pa_budget_versions bv

2387: (
2388: SELECT element_version_id,bv.budget_version_id
2389: FROM pa_proj_elem_ver_structure ppevs,
2390: pa_proj_structure_types ppst,
2391: pa_budget_versions bv
2392: WHERE 1=1
2393: and latest_eff_published_flag = 'Y'
2394: and ppst.proj_element_id = ppevs.proj_element_id
2395: and ppst.structure_type_id = 1

Line 2422: pa_budget_versions bv

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
2426: AND NVL(bv.wp_version_flag, 'N') = p_workplan_flag

Line 2450: pa_budget_versions bv

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
2454: AND NVL(bv.wp_version_flag , 'N') = p_workplan_flag

Line 3343: from PA_BUDGET_VERSIONS ver

3339: >= nvl(l_extr_start_date, to_date(1, 'J')) and
3340: prj.ORG_ID = pt.ORG_ID and
3341: prj.PROJECT_TYPE = pt.PROJECT_TYPE and
3342: prj.PROJECT_ID in (select ver.PROJECT_ID
3343: from PA_BUDGET_VERSIONS ver
3344: where ver.BUDGET_TYPE_CODE is null);
3345:
3346: PRINT_TIME ( ' FPM_UPGRADE_INITIALIZE 004 ' ) ;
3347:

Line 3479: FROM pa_budget_versions bv

3475: --AND prv.RBS_VERSION_ID not in ( 10000, 10142, 10224, 10821);
3476:
3477: CURSOR c_plan_versions (l_rbs_version_id NUMBER) IS -- This can be combined with the previous cursor.
3478: SELECT bv.budget_version_id, bv.project_id
3479: FROM pa_budget_versions bv
3480: , pa_proj_fp_options fpo
3481: WHERE 1=1
3482: AND bv.budget_version_id = fpo.fin_plan_version_id
3483: AND bv.fin_plan_type_id = fpo.fin_plan_type_id