APPS.PA_FP_CALC_PLAN_PKG dependencies on PA_PROJ_FP_OPTIONS

Line 21: g_fp_multi_curr_enabled pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;

17: g_resource_list_member_id pa_resource_assignments.resource_list_member_id%TYPE;
18: g_bv_resource_list_id pa_budget_versions.resource_list_id%TYPE;
19: g_resource_id NUMBER := to_number(null);
20: g_bv_approved_rev_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
21: g_fp_multi_curr_enabled pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
22: g_project_name pa_projects_all.name%TYPE;
23: g_task_name pa_proj_elements.name%TYPE;
24: g_resource_name pa_resource_list_members.alias%TYPE;
25: g_spread_required_flag VARCHAR2(1) := 'N';

Line 267: FROM pa_proj_fp_options pfo

263: /*Bugfix:4272944 */
264: ,NVL(pp.baseline_funding_flag,'N') baseline_funding_flag
265: ,decode(fpt.plan_class_code,'BUDGET'
266: ,decode(bv.wp_version_flag,'Y','WORKPLAN',fpt.plan_class_code),fpt.plan_class_code) Plan_Class_Type
267: FROM pa_proj_fp_options pfo
268: ,pa_budget_versions bv
269: ,pa_projects_all pp
270: ,pa_fin_plan_types_b fpt
271: WHERE pfo.fin_plan_version_id = bv.budget_version_id

Line 1386: FROM pa_proj_fp_options o

1382: ,o.project_cost_rate_date
1383: ,o.project_rev_rate_type
1384: ,o.project_rev_rate_date_type
1385: ,o.project_rev_rate_date
1386: FROM pa_proj_fp_options o
1387: ,pa_budget_versions v
1388: WHERE v.budget_version_id = p_budget_version_id
1389: AND o.project_id = v.project_id
1390: AND nvl(o.fin_plan_type_id,0) = nvl(v.fin_plan_type_id,0)

Line 4687: ,pa_proj_fp_options ppfo

4683: FROM gl_sets_of_books gsb
4684: ,pa_implementations_all pia
4685: ,pa_projects_all ppa
4686: ,pa_budget_versions pbv
4687: ,pa_proj_fp_options ppfo
4688: WHERE ppa.project_id = pbv.project_id
4689: AND pbv.budget_version_id = ppfo.fin_plan_version_id
4690: /* MOAC Changes: AND nvl(ppa.org_id,-99) = nvl(pia.org_id,-99) */
4691: AND ppa.org_id = pia.org_id

Line 8004: FROM pa_proj_fp_options pfo

8000: ,pp.segment1 project_Name
8001: ,bv.ci_id CiId
8002: /*Bugfix:4272944 */
8003: ,NVL(pp.baseline_funding_flag,'N') baseline_funding_flag
8004: FROM pa_proj_fp_options pfo
8005: ,pa_budget_versions bv
8006: ,pa_projects_all pp
8007: WHERE pfo.fin_plan_version_id = bv.budget_version_id
8008: AND bv.project_id = pp.project_id

Line 11750: FROM pa_proj_fp_options pfo

11746: ,pp.labor_sch_type
11747: ,pp.non_labor_sch_type
11748: ,bv.project_structure_version_id
11749: ,bv.project_id
11750: FROM pa_proj_fp_options pfo
11751: ,pa_budget_versions bv
11752: ,pa_projects_all pp
11753: WHERE pfo.fin_plan_version_id = bv.budget_version_id
11754: AND bv.budget_version_id = p_budget_version_id