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 604: ,PA_BUDGET_VERSIONS bv

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