DBA Data[Home] [Help]

APPS.PA_PLANNING_TRANSACTION_UTILS dependencies on PA_BUDGET_LINES

Line 747: ,pa_budget_lines pbl

743: ,pa_resource_assignments pra
744: ,pa_budget_versions pbv
745: ,pa_proj_fp_options pfo
746: ,pa_rbs_plans_out_tmp tmp
747: ,pa_budget_lines pbl
748: ,(SELECT 'OLD' as rbs_elem_id
749: FROM DUAL
750: UNION ALL
751: SELECT 'NEW' as rbs_elem_id

Line 850: ,pa_budget_lines pbl

846: ,pa_resource_assignments pra
847: ,pa_budget_versions pbv
848: ,pa_proj_fp_options pfo
849: ,pa_fp_ra_map_tmp tmp
850: ,pa_budget_lines pbl
851: WHERE p.project_id=pbv.project_id
852: AND pbv.budget_version_id=p_budget_version_id
853: AND pra.resource_assignment_id=tmp.target_res_assignment_id
854: AND pbv.budget_version_id=pra.budget_version_id

Line 1071: pa_budget_lines pbl,

1067: ,pra.CBS_ELEMENT_ID
1068: FROM pa_projects_all p,
1069: pa_proj_fp_options pfo,
1070: pa_budget_versions pbv,
1071: pa_budget_lines pbl,
1072: pa_resource_assignments pra
1073: WHERE p.project_id=pbv.project_id
1074: AND pbv.budget_version_id=p_budget_version_id
1075: AND pfo.fin_plan_version_id=p_budget_version_id