APPS.PA_PROGRESS_UTILS dependencies on PA_PROJ_FP_OPTIONS

Line 2994: pa_proj_fp_options ppfo

2990: ppfo.projfunc_cost_rate_date_type,
2991: ppfo.projfunc_cost_rate_date,
2992: ppfo.proj_fp_options_id
2993: FROM pa_projects_all ppa,
2994: pa_proj_fp_options ppfo
2995: WHERE ppa.project_id = p_project_id
2996: and ppfo.fin_plan_type_id = (select fin_plan_type_id
2997: from pa_fin_plan_types_b
2998: where use_for_workplan_flag = 'Y')

Line 3044: ,pa_proj_fp_options ppfo

3040: FROM gl_sets_of_books gsb
3041: ,pa_implementations_all pia
3042: ,pa_projects_all ppa
3043: ,pa_budget_versions pbv
3044: ,pa_proj_fp_options ppfo
3045: WHERE ppa.project_id = pbv.project_id
3046: AND pbv.budget_version_id = ppfo.fin_plan_version_id
3047: --AND nvl(ppa.org_id,-99) = nvl(pia.org_id,-99) R12: Bug 4363092:
3048: AND ppa.org_id = pia.org_id

Line 8939: FROM pa_proj_fp_options

8935: p_proj_str_ver_id => p_structure_version_id);
8936:
8937: -- Selecting res_class_raw_cost_sch_id here as it is not available in FP rec type
8938: SELECT use_planning_rates_flag,res_class_raw_cost_sch_id INTO l_use_planning_rates_flag, l_pl_res_class_raw_cost_sch_id
8939: FROM pa_proj_fp_options
8940: WHERE fin_plan_version_id = l_plan_version_id
8941: AND project_id = p_project_id;
8942:
8943: EXCEPTION

Line 8952: -- Bug 3691289 , rates from pa_proj_fp_options shd be selected always as we need them further even in actual rate mode

8948: pa_debug.write(x_Module=>'Pa_Fp_wp_gen_amt_utils.get_wp_version_id', x_Msg => 'p_error_text='||SUBSTRB('PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS:'||SQLERRM,1,120), x_Log_Level=> 3);
8949: raise fnd_api.g_exc_error;
8950: END;
8951:
8952: -- Bug 3691289 , rates from pa_proj_fp_options shd be selected always as we need them further even in actual rate mode
8953: -- IF p_calling_mode = 'PLAN_RATES'
8954: -- THEN
8955: -- Bug 4233420 : Moved the logic of getting rates from budget_lines up in the code here.
8956: IF l_etc_flag = 'Y' THEN

Line 12952: FROM pa_proj_fp_options ppfo, pa_budget_versions pbv

12948: END IF;
12949:
12950: --Code for getting the calendar id.
12951: SELECT ppfo.cost_time_phased_code INTO l_cal_type
12952: FROM pa_proj_fp_options ppfo, pa_budget_versions pbv
12953: WHERE pbv.project_id=p_project_id
12954: AND pbv.project_structure_version_id=p_structure_version_id
12955: AND pbv.budget_version_id=ppfo.fin_plan_version_id
12956: AND ppfo.fin_plan_option_level_code='PLAN_VERSION';