DBA Data[Home] [Help]

APPS.PA_FP_CALC_UTILS dependencies on PA_PROJ_FP_OPTIONS

Line 64: ,pa_proj_fp_options ppfo

60: FROM gl_sets_of_books gsb
61: ,pa_implementations_all pia
62: ,pa_projects_all ppa
63: ,pa_budget_versions pbv
64: ,pa_proj_fp_options ppfo
65: WHERE ppa.project_id = pbv.project_id
66: AND pbv.budget_version_id = ppfo.fin_plan_version_id
67: /* MOAC changes: AND nvl(ppa.org_id,-99) = nvl(pia.org_id,-99) */
68: AND ppa.org_id = pia.org_id

Line 96: FROM pa_proj_fp_options pfo

92: ,bv.project_id
93: ,bv.ci_id ciId
94: ,decode(fpt.plan_class_code,'BUDGET'
95: ,decode(bv.wp_version_flag,'Y','WORKPLAN',fpt.plan_class_code),fpt.plan_class_code) Plan_Class_Type
96: FROM pa_proj_fp_options pfo
97: ,pa_budget_versions bv
98: ,pa_projects_all pp
99: ,pa_fin_plan_types_b fpt
100: WHERE pfo.fin_plan_version_id = bv.budget_version_id

Line 4218: ,pa_proj_fp_options ppfo

4214: FROM gl_sets_of_books gsb
4215: ,pa_implementations_all pia
4216: ,pa_projects_all ppa
4217: ,pa_budget_versions pbv
4218: ,pa_proj_fp_options ppfo
4219: WHERE ppa.project_id = pbv.project_id
4220: AND pbv.budget_version_id = ppfo.fin_plan_version_id
4221: AND ppa.org_id = pia.org_id
4222: AND gsb.set_of_books_id = pia.set_of_books_id