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_BUDGET_VERSIONS

Line 100: ,PA_BUDGET_VERSIONS bv

96: -- Bottom Up Flow
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

Line 121: ,PA_BUDGET_VERSIONS bv

117: FROM
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

Line 135: ,PA_BUDGET_VERSIONS bv

131: AND evs.status_code = 'STRUCTURE_WORKING')
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

Line 1336: ,PA_BUDGET_VERSIONS bv

1332: FROM
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

Line 1349: ,PA_BUDGET_VERSIONS bv

1345: AND evs.status_code = 'STRUCTURE_WORKING')
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

Line 1371: ,PA_BUDGET_VERSIONS bv

1367: FROM
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

Line 1383: ,PA_BUDGET_VERSIONS bv

1379: AND evs.status_code = 'STRUCTURE_WORKING')
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