APPS.PA_ASSIGNMENTS_PUB dependencies on PA_PROJ_ELEM_VER_STRUCTURE

Line 2140: ,PA_PROJ_ELEM_VER_STRUCTURE evs

2136: (
2137: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id
2138: FROM PA_RESOURCE_ASSIGNMENTS ra
2139: ,PA_BUDGET_VERSIONS bv
2140: ,PA_PROJ_ELEM_VER_STRUCTURE evs
2141: WHERE ra.project_id = bv.project_id
2142: AND bv.project_id = evs.project_id
2143: AND ra.budget_version_id = bv.budget_version_id
2144: AND bv.project_structure_version_id = evs.element_version_id

Line 2152: ,PA_PROJ_ELEM_VER_STRUCTURE evs

2148: UNION ALL
2149: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id
2150: FROM PA_RESOURCE_ASSIGNMENTS ra
2151: ,PA_BUDGET_VERSIONS bv
2152: ,PA_PROJ_ELEM_VER_STRUCTURE evs
2153: ,PA_PROJ_WORKPLAN_ATTR pwa
2154: WHERE pwa.wp_enable_Version_flag = 'N'
2155: AND pwa.project_id = ra.project_id
2156: AND pwa.proj_element_id = evs.proj_element_id

Line 2173: ,PA_PROJ_ELEM_VER_STRUCTURE evs

2169: (
2170: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id, ra.task_id
2171: FROM PA_RESOURCE_ASSIGNMENTS ra
2172: ,PA_BUDGET_VERSIONS bv
2173: ,PA_PROJ_ELEM_VER_STRUCTURE evs
2174: WHERE ra.project_id = bv.project_id
2175: AND bv.project_id = evs.project_id
2176: AND ra.budget_version_id = bv.budget_version_id
2177: AND bv.project_structure_version_id = evs.element_version_id

Line 2185: ,PA_PROJ_ELEM_VER_STRUCTURE evs

2181: UNION ALL
2182: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id, ra.task_id
2183: FROM PA_RESOURCE_ASSIGNMENTS ra
2184: ,PA_BUDGET_VERSIONS bv
2185: ,PA_PROJ_ELEM_VER_STRUCTURE evs
2186: ,PA_PROJ_WORKPLAN_ATTR pwa
2187: WHERE pwa.wp_enable_Version_flag = 'N'
2188: AND pwa.project_id = ra.project_id
2189: AND pwa.proj_element_id = evs.proj_element_id

Line 2215: ,PA_PROJ_ELEM_VER_STRUCTURE evs

2211: (
2212: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id, ra.task_id
2213: FROM PA_RESOURCE_ASSIGNMENTS ra
2214: ,PA_BUDGET_VERSIONS bv
2215: ,PA_PROJ_ELEM_VER_STRUCTURE evs
2216: WHERE ra.project_id = bv.project_id
2217: AND bv.project_id = evs.project_id
2218: AND ra.budget_version_id = bv.budget_version_id
2219: AND bv.project_structure_version_id = evs.element_version_id

Line 2227: ,PA_PROJ_ELEM_VER_STRUCTURE evs

2223: UNION ALL
2224: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id, ra.task_id
2225: FROM PA_RESOURCE_ASSIGNMENTS ra
2226: ,PA_BUDGET_VERSIONS bv
2227: ,PA_PROJ_ELEM_VER_STRUCTURE evs
2228: ,PA_PROJ_WORKPLAN_ATTR pwa
2229: WHERE pwa.wp_enable_Version_flag = 'N'
2230: AND pwa.project_id = ra.project_id
2231: AND pwa.proj_element_id = evs.proj_element_id