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 1337: ,PA_PROJ_ELEM_VER_STRUCTURE evs

1333: (
1334: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id
1335: FROM PA_RESOURCE_ASSIGNMENTS ra
1336: ,PA_BUDGET_VERSIONS bv
1337: ,PA_PROJ_ELEM_VER_STRUCTURE evs
1338: WHERE ra.project_id = bv.project_id
1339: AND bv.project_id = evs.project_id
1340: AND ra.budget_version_id = bv.budget_version_id
1341: AND bv.project_structure_version_id = evs.element_version_id

Line 1350: ,PA_PROJ_ELEM_VER_STRUCTURE evs

1346: UNION ALL
1347: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id
1348: FROM PA_RESOURCE_ASSIGNMENTS ra
1349: ,PA_BUDGET_VERSIONS bv
1350: ,PA_PROJ_ELEM_VER_STRUCTURE evs
1351: ,PA_PROJ_WORKPLAN_ATTR pwa
1352: WHERE pwa.wp_enable_Version_flag = 'N'
1353: AND pwa.project_id = ra.project_id
1354: AND pwa.proj_element_id = evs.proj_element_id

Line 1372: ,PA_PROJ_ELEM_VER_STRUCTURE evs

1368: (
1369: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id
1370: FROM PA_RESOURCE_ASSIGNMENTS ra
1371: ,PA_BUDGET_VERSIONS bv
1372: ,PA_PROJ_ELEM_VER_STRUCTURE evs
1373: WHERE ra.project_id = bv.project_id
1374: AND bv.project_id = evs.project_id
1375: AND ra.budget_version_id = bv.budget_version_id
1376: AND bv.project_structure_version_id = evs.element_version_id

Line 1384: ,PA_PROJ_ELEM_VER_STRUCTURE evs

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