APPS.PJI_FM_XBS_ACCUM_MAINT dependencies on PA_PROJ_FP_OPTIONS

Line 470: from pa_budget_versions b , pa_projects_all p , pa_proj_fp_options fpo

466: for k in 1 .. p_fp_version_ids.count loop
467:
468: select p.pjt_rollup_enabled_flag , p.cbs_enable_flag, p.project_id , fpo.rbs_version_id , p.cbs_version_id
469: into l_pjt_rollup_enabled_flag , l_cbs_enabled_flag, l_project_id , l_rbs_version_id , l_cbs_version_id
470: from pa_budget_versions b , pa_projects_all p , pa_proj_fp_options fpo
471: where b.budget_version_id = p_fp_version_ids(k)
472: and b.project_id = p.project_id
473: AND b.fin_plan_type_id = fpo.fin_plan_type_id
474: AND b.budget_version_id = fpo.fin_plan_version_id

Line 578: FROM pa_proj_fp_options a, pa_budget_versions b

574: CURSOR res_list IS
575: SELECT decode(b.version_type, 'COST', cost_resource_list_id,
576: 'REVENUE',revenue_resource_list_id,
577: 'ALL', all_resource_list_id) resource_list_id
578: FROM pa_proj_fp_options a, pa_budget_versions b
579: WHERE a.fin_plan_version_id = b.budget_version_id
580: AND a.fin_plan_version_id = p_plan_version_id;
581:
582: CURSOR res_class IS

Line 591: from pa_budget_versions b , pa_projects_all p , pa_proj_fp_options fpo, pji_fm_extr_plan_lines extr

587: -- OLAP START CHANGE
588:
589: cursor plan_versions is
590: select extr.plan_version_id, p.pjt_rollup_enabled_flag , nvl(p.CBS_ENABLE_FLAG, 'N') cbs_enable_flag, p.project_id , fpo.rbs_version_id , p.cbs_version_id
591: from pa_budget_versions b , pa_projects_all p , pa_proj_fp_options fpo, pji_fm_extr_plan_lines extr
592: where b.budget_version_id = extr.plan_version_id
593: and b.project_id = p.project_id
594: AND b.fin_plan_type_id = fpo.fin_plan_type_id
595: AND b.budget_version_id = fpo.fin_plan_version_id

Line 709: from pa_budget_versions b , pa_projects_all p , pa_proj_fp_options fpo

705: END IF;
706:
707: select p.pjt_rollup_enabled_flag , p.CBS_ENABLE_FLAG, p.project_id , fpo.rbs_version_id , p.cbs_version_id
708: into l_pjt_rollup_enabled_flag , l_cbs_enable_flag, l_project_id , l_rbs_version_id , l_cbs_version_id
709: from pa_budget_versions b , pa_projects_all p , pa_proj_fp_options fpo
710: where b.budget_version_id = p_plan_version_id
711: and b.project_id = p.project_id
712: AND b.fin_plan_type_id = fpo.fin_plan_type_id
713: AND b.budget_version_id = fpo.fin_plan_version_id

Line 1493: from pa_budget_versions b , pa_projects_all p , pa_proj_fp_options fpo

1489: -- OLAP START CHANGE
1490:
1491: select p.pjt_rollup_enabled_flag , p.cbs_enable_flag, p.project_id , fpo.rbs_version_id , p.cbs_version_id
1492: into l_pjt_rollup_enabled_flag , l_cbs_enabled_flag, l_project_id , l_rbs_version_id , l_cbs_version_id
1493: from pa_budget_versions b , pa_projects_all p , pa_proj_fp_options fpo
1494: where b.budget_version_id = p_dest_fp_version_ids(i)
1495: and b.project_id = p.project_id
1496: AND b.fin_plan_type_id = fpo.fin_plan_type_id
1497: AND b.budget_version_id = fpo.fin_plan_version_id

Line 1798: from pa_budget_versions b , pa_projects_all p , pa_proj_fp_options fpo

1794: -- OLAP START CHANGE
1795:
1796: select p.pjt_rollup_enabled_flag , p.cbs_enable_flag, p.project_id , fpo.rbs_version_id , p.cbs_version_id
1797: into l_pjt_rollup_enabled_flag , l_cbs_enabled_flag, l_project_id , l_rbs_version_id , l_cbs_version_id
1798: from pa_budget_versions b , pa_projects_all p , pa_proj_fp_options fpo
1799: where b.budget_version_id = p_new_version_id
1800: and b.project_id = p.project_id
1801: AND b.fin_plan_type_id = fpo.fin_plan_type_id
1802: AND b.budget_version_id = fpo.fin_plan_version_id

Line 5887: from pa_budget_versions b , pa_proj_fp_options fpo

5883: begin
5884:
5885: select fpo.rbs_version_id
5886: into l_new_rbs_version_id
5887: from pa_budget_versions b , pa_proj_fp_options fpo
5888: where b.budget_version_id =p_plan_version_id_tbl(i)
5889: AND b.fin_plan_type_id = fpo.fin_plan_type_id
5890: AND b.budget_version_id = fpo.fin_plan_version_id
5891: AND b.project_id = fpo.project_id