APPS.PA_OPEN_ASSIGNMENT_PVT dependencies on PA_PROJ_ELEM_VER_STRUCTURE

Line 102: ,PA_PROJ_ELEM_VER_STRUCTURE evs

98: CURSOR get_bu_resource_assignments IS
99: SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id
100: FROM PA_RESOURCE_ASSIGNMENTS ra
101: ,PA_BUDGET_VERSIONS bv
102: ,PA_PROJ_ELEM_VER_STRUCTURE evs
103: WHERE ra.project_id = bv.project_id
104: AND bv.project_id = evs.project_id
105: AND ra.budget_version_id = bv.budget_version_id
106: AND bv.project_structure_version_id = evs.element_version_id

Line 122: ,PA_PROJ_ELEM_VER_STRUCTURE evs

118: (
119: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id
120: FROM PA_RESOURCE_ASSIGNMENTS ra
121: ,PA_BUDGET_VERSIONS bv
122: ,PA_PROJ_ELEM_VER_STRUCTURE evs
123: WHERE ra.project_id = bv.project_id
124: AND bv.project_id = evs.project_id
125: AND ra.budget_version_id = bv.budget_version_id
126: AND bv.project_structure_version_id = evs.element_version_id

Line 135: ,PA_PROJ_ELEM_VER_STRUCTURE evs

131: UNION ALL
132: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id
133: FROM PA_RESOURCE_ASSIGNMENTS ra
134: ,PA_BUDGET_VERSIONS bv
135: ,PA_PROJ_ELEM_VER_STRUCTURE evs
136: ,PA_PROJ_WORKPLAN_ATTR pwa
137: WHERE pwa.wp_enable_Version_flag = 'N'
138: AND pwa.project_id = ra.project_id
139: AND pwa.proj_element_id = evs.proj_element_id

Line 1232: ,PA_PROJ_ELEM_VER_STRUCTURE evs

1228: (
1229: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id
1230: FROM PA_RESOURCE_ASSIGNMENTS ra
1231: ,PA_BUDGET_VERSIONS bv
1232: ,PA_PROJ_ELEM_VER_STRUCTURE evs
1233: WHERE ra.project_id = bv.project_id
1234: AND bv.project_id = evs.project_id
1235: AND ra.budget_version_id = bv.budget_version_id
1236: AND bv.project_structure_version_id = evs.element_version_id

Line 1245: ,PA_PROJ_ELEM_VER_STRUCTURE evs

1241: UNION ALL
1242: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id
1243: FROM PA_RESOURCE_ASSIGNMENTS ra
1244: ,PA_BUDGET_VERSIONS bv
1245: ,PA_PROJ_ELEM_VER_STRUCTURE evs
1246: ,PA_PROJ_WORKPLAN_ATTR pwa
1247: WHERE pwa.wp_enable_Version_flag = 'N'
1248: AND pwa.project_id = ra.project_id
1249: AND pwa.proj_element_id = evs.proj_element_id

Line 1267: ,PA_PROJ_ELEM_VER_STRUCTURE evs

1263: (
1264: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id
1265: FROM PA_RESOURCE_ASSIGNMENTS ra
1266: ,PA_BUDGET_VERSIONS bv
1267: ,PA_PROJ_ELEM_VER_STRUCTURE evs
1268: WHERE ra.project_id = bv.project_id
1269: AND bv.project_id = evs.project_id
1270: AND ra.budget_version_id = bv.budget_version_id
1271: AND bv.project_structure_version_id = evs.element_version_id

Line 1279: ,PA_PROJ_ELEM_VER_STRUCTURE evs

1275: UNION ALL
1276: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id
1277: FROM PA_RESOURCE_ASSIGNMENTS ra
1278: ,PA_BUDGET_VERSIONS bv
1279: ,PA_PROJ_ELEM_VER_STRUCTURE evs
1280: ,PA_PROJ_WORKPLAN_ATTR pwa
1281: WHERE pwa.wp_enable_Version_flag = 'N'
1282: AND pwa.project_id = ra.project_id
1283: AND pwa.proj_element_id = evs.proj_element_id