APPS.PA_PROGRESS_UTILS dependencies on PA_PROJ_FP_OPTIONS

Line 3019: pa_proj_fp_options ppfo

3015: ppfo.projfunc_cost_rate_date_type,
3016: ppfo.projfunc_cost_rate_date,
3017: ppfo.proj_fp_options_id
3018: FROM pa_projects_all ppa,
3019: pa_proj_fp_options ppfo
3020: WHERE ppa.project_id = p_project_id
3021: and ppfo.fin_plan_type_id = (select fin_plan_type_id
3022: from pa_fin_plan_types_b
3023: where use_for_workplan_flag = 'Y')

Line 3069: ,pa_proj_fp_options ppfo

3065: FROM gl_sets_of_books gsb
3066: ,pa_implementations_all pia
3067: ,pa_projects_all ppa
3068: ,pa_budget_versions pbv
3069: ,pa_proj_fp_options ppfo
3070: WHERE ppa.project_id = pbv.project_id
3071: AND pbv.budget_version_id = ppfo.fin_plan_version_id
3072: --AND nvl(ppa.org_id,-99) = nvl(pia.org_id,-99) R12: Bug 4363092:
3073: AND ppa.org_id = pia.org_id

Line 8995: FROM pa_proj_fp_options

8991: p_proj_str_ver_id => p_structure_version_id);
8992:
8993: -- Selecting res_class_raw_cost_sch_id here as it is not available in FP rec type
8994: 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
8995: FROM pa_proj_fp_options
8996: WHERE fin_plan_version_id = l_plan_version_id
8997: AND project_id = p_project_id;
8998:
8999: EXCEPTION

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

9004: 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);
9005: raise fnd_api.g_exc_error;
9006: END;
9007:
9008: -- Bug 3691289 , rates from pa_proj_fp_options shd be selected always as we need them further even in actual rate mode
9009: -- IF p_calling_mode = 'PLAN_RATES'
9010: -- THEN
9011: -- Bug 4233420 : Moved the logic of getting rates from budget_lines up in the code here.
9012: IF l_etc_flag = 'Y' THEN

Line 13049: FROM pa_proj_fp_options ppfo, pa_budget_versions pbv

13045: END IF;
13046:
13047: --Code for getting the calendar id.
13048: SELECT ppfo.cost_time_phased_code INTO l_cal_type
13049: FROM pa_proj_fp_options ppfo, pa_budget_versions pbv
13050: WHERE pbv.project_id=p_project_id
13051: AND pbv.project_structure_version_id=p_structure_version_id
13052: AND pbv.budget_version_id=ppfo.fin_plan_version_id
13053: AND ppfo.fin_plan_option_level_code='PLAN_VERSION';