DBA Data[Home] [Help]

APPS.PA_ASSIGNMENT_APPROVAL_PUB dependencies on PA_PROJ_ELEM_VER_STRUCTURE

Line 1671: ,PA_PROJ_ELEM_VER_STRUCTURE evs

1667: (
1668: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id
1669: FROM PA_RESOURCE_ASSIGNMENTS ra
1670: ,PA_BUDGET_VERSIONS bv
1671: ,PA_PROJ_ELEM_VER_STRUCTURE evs
1672: -- ,PA_PROJECT_ASSIGNMENTS pa -- 5110598 Removed PA_PROJECT_ASSIGNMENTS table usage
1673: WHERE ra.project_id = bv.project_id
1674: AND bv.project_id = evs.project_id
1675: AND ra.budget_version_id = bv.budget_version_id

Line 1686: ,PA_PROJ_ELEM_VER_STRUCTURE evs

1682: UNION ALL
1683: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id
1684: FROM PA_RESOURCE_ASSIGNMENTS ra
1685: ,PA_BUDGET_VERSIONS bv
1686: ,PA_PROJ_ELEM_VER_STRUCTURE evs
1687: ,PA_PROJ_WORKPLAN_ATTR pwa
1688: -- ,PA_PROJECT_ASSIGNMENTS pa -- 5110598 Removed PA_PROJECT_ASSIGNMENTS table usage
1689: WHERE pwa.wp_enable_Version_flag = 'N'
1690: AND pwa.project_id = ra.project_id