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 bv.budget_type_code IS NULL -- added for bug#9095861

Line 122: ,PA_BUDGET_VERSIONS bv

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

Line 136: ,PA_BUDGET_VERSIONS bv

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

Line 1237: ,PA_BUDGET_VERSIONS bv

1233: FROM
1234: (
1235: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id
1236: FROM PA_RESOURCE_ASSIGNMENTS ra
1237: ,PA_BUDGET_VERSIONS bv
1238: ,PA_PROJ_ELEM_VER_STRUCTURE evs
1239: WHERE ra.project_id = bv.project_id
1240: AND bv.project_id = evs.project_id
1241: AND ra.budget_version_id = bv.budget_version_id

Line 1250: ,PA_BUDGET_VERSIONS bv

1246: AND evs.status_code = 'STRUCTURE_WORKING')
1247: UNION ALL
1248: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id
1249: FROM PA_RESOURCE_ASSIGNMENTS ra
1250: ,PA_BUDGET_VERSIONS bv
1251: ,PA_PROJ_ELEM_VER_STRUCTURE evs
1252: ,PA_PROJ_WORKPLAN_ATTR pwa
1253: WHERE pwa.wp_enable_Version_flag = 'N'
1254: AND pwa.project_id = ra.project_id

Line 1272: ,PA_BUDGET_VERSIONS bv

1268: FROM
1269: (
1270: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id
1271: FROM PA_RESOURCE_ASSIGNMENTS ra
1272: ,PA_BUDGET_VERSIONS bv
1273: ,PA_PROJ_ELEM_VER_STRUCTURE evs
1274: WHERE ra.project_id = bv.project_id
1275: AND bv.project_id = evs.project_id
1276: AND ra.budget_version_id = bv.budget_version_id

Line 1284: ,PA_BUDGET_VERSIONS bv

1280: AND evs.status_code = 'STRUCTURE_WORKING')
1281: UNION ALL
1282: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id
1283: FROM PA_RESOURCE_ASSIGNMENTS ra
1284: ,PA_BUDGET_VERSIONS bv
1285: ,PA_PROJ_ELEM_VER_STRUCTURE evs
1286: ,PA_PROJ_WORKPLAN_ATTR pwa
1287: WHERE pwa.wp_enable_Version_flag = 'N'
1288: AND pwa.project_id = ra.project_id