DBA Data[Home] [Help]

APPS.PA_FP_CALC_UTILS dependencies on PA_BUDGET_VERSIONS

Line 70: ,pa_budget_versions pbv

66: ppfo.all_time_phased_code) time_phased_code
67: FROM gl_sets_of_books gsb
68: ,pa_implementations_all pia
69: ,pa_projects_all ppa
70: ,pa_budget_versions pbv
71: ,pa_proj_fp_options ppfo
72: WHERE ppa.project_id = pbv.project_id
73: AND pbv.budget_version_id = ppfo.fin_plan_version_id
74: /* MOAC changes: AND nvl(ppa.org_id,-99) = nvl(pia.org_id,-99) */

Line 104: ,pa_budget_versions bv

100: ,bv.ci_id ciId
101: ,decode(fpt.plan_class_code,'BUDGET'
102: ,decode(bv.wp_version_flag,'Y','WORKPLAN',fpt.plan_class_code),fpt.plan_class_code) Plan_Class_Type
103: FROM pa_proj_fp_options pfo
104: ,pa_budget_versions bv
105: ,pa_projects_all pp
106: ,pa_fin_plan_types_b fpt
107: WHERE pfo.fin_plan_version_id = bv.budget_version_id
108: AND bv.project_id = pp.project_id

Line 4246: ,pa_budget_versions pbv

4242: ,pia.pa_period_type pa_period_type
4243: FROM gl_sets_of_books gsb
4244: ,pa_implementations_all pia
4245: ,pa_projects_all ppa
4246: ,pa_budget_versions pbv
4247: ,pa_proj_fp_options ppfo
4248: WHERE ppa.project_id = pbv.project_id
4249: AND pbv.budget_version_id = ppfo.fin_plan_version_id
4250: AND ppa.org_id = pia.org_id