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_OPEN_ASSIGNMENT_PVT dependencies on PA_BUDGET_VERSIONS

Line 101: ,PA_BUDGET_VERSIONS bv

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

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 ra.budget_version_id = bv.budget_version_id

Line 134: ,PA_BUDGET_VERSIONS bv

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

Line 1231: ,PA_BUDGET_VERSIONS bv

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

Line 1244: ,PA_BUDGET_VERSIONS bv

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

Line 1266: ,PA_BUDGET_VERSIONS bv

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

Line 1278: ,PA_BUDGET_VERSIONS bv

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