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

Line 2202: ,PA_BUDGET_VERSIONS bv

2198: FROM
2199: (
2200: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id
2201: FROM PA_RESOURCE_ASSIGNMENTS ra
2202: ,PA_BUDGET_VERSIONS bv
2203: ,PA_PROJ_ELEM_VER_STRUCTURE evs
2204: WHERE ra.project_id = bv.project_id
2205: AND bv.project_id = evs.project_id
2206: AND ra.budget_version_id = bv.budget_version_id

Line 2214: ,PA_BUDGET_VERSIONS bv

2210: AND evs.status_code = 'STRUCTURE_WORKING')
2211: UNION ALL
2212: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id
2213: FROM PA_RESOURCE_ASSIGNMENTS ra
2214: ,PA_BUDGET_VERSIONS bv
2215: ,PA_PROJ_ELEM_VER_STRUCTURE evs
2216: ,PA_PROJ_WORKPLAN_ATTR pwa
2217: WHERE pwa.wp_enable_Version_flag = 'N'
2218: AND pwa.project_id = ra.project_id

Line 2235: ,PA_BUDGET_VERSIONS bv

2231: FROM
2232: (
2233: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id, ra.task_id
2234: FROM PA_RESOURCE_ASSIGNMENTS ra
2235: ,PA_BUDGET_VERSIONS bv
2236: ,PA_PROJ_ELEM_VER_STRUCTURE evs
2237: WHERE ra.project_id = bv.project_id
2238: AND bv.project_id = evs.project_id
2239: AND ra.budget_version_id = bv.budget_version_id

Line 2247: ,PA_BUDGET_VERSIONS bv

2243: AND evs.status_code = 'STRUCTURE_WORKING')
2244: UNION ALL
2245: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id, ra.task_id
2246: FROM PA_RESOURCE_ASSIGNMENTS ra
2247: ,PA_BUDGET_VERSIONS bv
2248: ,PA_PROJ_ELEM_VER_STRUCTURE evs
2249: ,PA_PROJ_WORKPLAN_ATTR pwa
2250: WHERE pwa.wp_enable_Version_flag = 'N'
2251: AND pwa.project_id = ra.project_id

Line 2277: ,PA_BUDGET_VERSIONS bv

2273: FROM
2274: (
2275: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id, ra.task_id
2276: FROM PA_RESOURCE_ASSIGNMENTS ra
2277: ,PA_BUDGET_VERSIONS bv
2278: ,PA_PROJ_ELEM_VER_STRUCTURE evs
2279: WHERE ra.project_id = bv.project_id
2280: AND bv.project_id = evs.project_id
2281: AND ra.budget_version_id = bv.budget_version_id

Line 2289: ,PA_BUDGET_VERSIONS bv

2285: AND evs.status_code = 'STRUCTURE_WORKING')
2286: UNION ALL
2287: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id, ra.task_id
2288: FROM PA_RESOURCE_ASSIGNMENTS ra
2289: ,PA_BUDGET_VERSIONS bv
2290: ,PA_PROJ_ELEM_VER_STRUCTURE evs
2291: ,PA_PROJ_WORKPLAN_ATTR pwa
2292: WHERE pwa.wp_enable_Version_flag = 'N'
2293: AND pwa.project_id = ra.project_id