DBA Data[Home] [Help]

APPS.PA_ASSIGNMENTS_PVT dependencies on PA_BUDGET_VERSIONS

Line 588: ,PA_BUDGET_VERSIONS bv

584: FROM
585: (
586: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id
587: FROM PA_RESOURCE_ASSIGNMENTS ra
588: ,PA_BUDGET_VERSIONS bv
589: ,PA_PROJ_ELEM_VER_STRUCTURE evs
590: -- ,PA_PROJECT_ASSIGNMENTS pa -- 5110598 Removed PA_PROJECT_ASSIGNMENTS table usage
591: WHERE ra.project_id = bv.project_id
592: AND bv.project_id = evs.project_id

Line 603: ,PA_BUDGET_VERSIONS bv

599: AND evs.status_code = 'STRUCTURE_WORKING')
600: UNION ALL
601: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id
602: FROM PA_RESOURCE_ASSIGNMENTS ra
603: ,PA_BUDGET_VERSIONS bv
604: ,PA_PROJ_ELEM_VER_STRUCTURE evs
605: ,PA_PROJ_WORKPLAN_ATTR pwa
606: -- ,PA_PROJECT_ASSIGNMENTS pa -- 5110598 Removed PA_PROJECT_ASSIGNMENTS table usage
607: WHERE pwa.wp_enable_Version_flag = 'N'