eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_STAFFED_ASSIGNMENT_PVT dependencies on PA_PROJ_ELEM_VER_STRUCTURE

Line 101: ,PA_PROJ_ELEM_VER_STRUCTURE evs

97: CURSOR get_bu_resource_assignments IS
98: SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id
99: FROM PA_RESOURCE_ASSIGNMENTS ra
100: ,PA_BUDGET_VERSIONS bv
101: ,PA_PROJ_ELEM_VER_STRUCTURE evs
102: WHERE ra.project_id = bv.project_id
103: AND bv.project_id = evs.project_id
104: AND bv.budget_type_code IS NULL -- added for bug 7492618
105: AND ra.budget_version_id = bv.budget_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 bv.budget_type_code IS NULL -- added for bug 7492618
126: AND ra.budget_version_id = bv.budget_version_id

Line 136: ,PA_PROJ_ELEM_VER_STRUCTURE evs

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

Line 1368: ,PA_PROJ_ELEM_VER_STRUCTURE evs

1364: (
1365: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id
1366: FROM PA_RESOURCE_ASSIGNMENTS ra
1367: ,PA_BUDGET_VERSIONS bv
1368: ,PA_PROJ_ELEM_VER_STRUCTURE evs
1369: WHERE ra.project_id = bv.project_id
1370: AND bv.project_id = evs.project_id
1371: AND ra.budget_version_id = bv.budget_version_id
1372: AND bv.project_structure_version_id = evs.element_version_id

Line 1381: ,PA_PROJ_ELEM_VER_STRUCTURE evs

1377: UNION ALL
1378: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id
1379: FROM PA_RESOURCE_ASSIGNMENTS ra
1380: ,PA_BUDGET_VERSIONS bv
1381: ,PA_PROJ_ELEM_VER_STRUCTURE evs
1382: ,PA_PROJ_WORKPLAN_ATTR pwa
1383: WHERE pwa.wp_enable_Version_flag = 'N'
1384: AND pwa.project_id = ra.project_id
1385: AND pwa.proj_element_id = evs.proj_element_id

Line 1403: ,PA_PROJ_ELEM_VER_STRUCTURE evs

1399: (
1400: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id
1401: FROM PA_RESOURCE_ASSIGNMENTS ra
1402: ,PA_BUDGET_VERSIONS bv
1403: ,PA_PROJ_ELEM_VER_STRUCTURE evs
1404: WHERE ra.project_id = bv.project_id
1405: AND bv.project_id = evs.project_id
1406: AND ra.budget_version_id = bv.budget_version_id
1407: AND bv.project_structure_version_id = evs.element_version_id

Line 1415: ,PA_PROJ_ELEM_VER_STRUCTURE evs

1411: UNION ALL
1412: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id
1413: FROM PA_RESOURCE_ASSIGNMENTS ra
1414: ,PA_BUDGET_VERSIONS bv
1415: ,PA_PROJ_ELEM_VER_STRUCTURE evs
1416: ,PA_PROJ_WORKPLAN_ATTR pwa
1417: WHERE pwa.wp_enable_Version_flag = 'N'
1418: AND pwa.project_id = ra.project_id
1419: AND pwa.proj_element_id = evs.proj_element_id