DBA Data[Home] [Help]

APPS.PA_RLMI_RBS_MAP_PUB dependencies on PA_PROJECTS_ALL

Line 2860: ,pa_projects_all pp

2856: ,fptyp.name plan_type_name
2857: FROM pa_budget_versions bv
2858: ,pa_proj_fp_options fp
2859: -- ,pji_pjp_proj_batch_map rbs -- Bug 16841995 - The templates should also be updated with the latest rbs_version_id
2860: ,pa_projects_all pp
2861: ,pa_fin_plan_types_tl fptyp
2862: ,pa_rbs_versions_b rvb -- Added for Bug 6450168
2863: WHERE bv.budget_version_id (+) = fp.fin_plan_version_id
2864: AND nvl(bv.project_id,fp.project_id) = fp.project_id

Line 2890: ,pa_projects_all pp

2886: ,fptyp.name plan_type_name
2887: FROM pa_budget_versions bv
2888: ,pa_proj_fp_options fp
2889: --,pji_pjp_proj_batch_map rbs
2890: ,pa_projects_all pp
2891: ,pa_fin_plan_types_tl fptyp
2892: ,pa_rbs_versions_b rvb -- Added for Bug 6450168
2893: WHERE bv.budget_version_id (+) = fp.fin_plan_version_id
2894: AND nvl(bv.project_id,fp.project_id) = fp.project_id