APPS.PA_BUDGET_UTILS dependencies on PA_PROJ_FP_OPTIONS

Line 3985: l_ac_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE := NULL;

3981:
3982: IS
3983:
3984:
3985: l_ac_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE := NULL;
3986: l_ar_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE := NULL;
3987: l_ac_version_type pa_budget_versions.version_type%TYPE := NULL;
3988: l_ar_version_type pa_budget_versions.version_type%TYPE := NULL;
3989:

Line 3986: l_ar_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE := NULL;

3982: IS
3983:
3984:
3985: l_ac_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE := NULL;
3986: l_ar_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE := NULL;
3987: l_ac_version_type pa_budget_versions.version_type%TYPE := NULL;
3988: l_ar_version_type pa_budget_versions.version_type%TYPE := NULL;
3989:
3990: l_dummy VARCHAR2(1) := 'N';

Line 4044: FROM pa_proj_fp_options o

4040: BEGIN
4041: -- AC
4042: SELECT o.fin_plan_type_id, v.version_type
4043: INTO l_ac_plan_type_id, l_ac_version_type
4044: FROM pa_proj_fp_options o
4045: , pa_budget_versions v
4046: WHERE o.fin_plan_version_id = v.budget_version_id
4047: AND v.approved_cost_plan_type_flag = 'Y'
4048: AND v.current_flag = 'Y'

Line 4064: FROM pa_proj_fp_options o

4060:
4061: -- AR
4062: SELECT o.fin_plan_type_id, v.version_type
4063: INTO l_ar_plan_type_id, l_ar_version_type
4064: FROM pa_proj_fp_options o
4065: , pa_budget_versions v
4066: WHERE o.fin_plan_version_id = v.budget_version_id
4067: AND v.approved_rev_plan_type_flag = 'Y'
4068: AND v.current_flag = 'Y'