APPS.PA_BUDGET_UTILS2 dependencies on PA_PROJ_FP_OPTIONS

Line 48: ,pa_proj_fp_options fo

44: and nvl(bt.plan_type,'BUDGET') = 'BUDGET'
45: UNION ALL
46: select 'Y'
47: from pa_budget_versions v
48: ,pa_proj_fp_options fo
49: where v.project_id = x_project_id
50: and v.budget_version_id = fo.fin_plan_version_id
51: and (fo.all_time_phased_code = 'N'
52: OR fo.cost_time_phased_code = 'N'

Line 79: ,pa_proj_fp_options fo

75: and 'X' = DECODE(l_baseline_funding, 'Y', DECODE(v.budget_type_code, 'AR', 'Z', 'X'), 'X') --Bug 5098809.
76: UNION ALL
77: select 'Y'
78: from pa_budget_versions v
79: ,pa_proj_fp_options fo
80: where v.project_id = x_project_id
81: and v.budget_version_id = fo.fin_plan_version_id
82: and fo.project_id = v.project_id -- raja perf bug 3683360
83: and fo.fin_plan_type_id = v.fin_plan_type_id -- raja perf bug 3683360

Line 111: ,pa_proj_fp_options fo

107: and 'X' = DECODE(l_baseline_funding, 'Y', DECODE(v.budget_type_code, 'AR', 'Z', 'X'), 'X') --Bug 5098809.
108: UNION ALL
109: select 'Y'
110: from pa_budget_versions v
111: ,pa_proj_fp_options fo
112: where v.project_id = x_project_id
113: and v.budget_version_id = fo.fin_plan_version_id
114: and fo.project_id = v.project_id -- raja perf bug 3683360
115: and fo.fin_plan_type_id = v.fin_plan_type_id -- raja perf bug 3683360