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_ASSIGNMENT_APPROVAL_PUB dependencies on PA_RESOURCE_ASSIGNMENTS

Line 1669: FROM PA_RESOURCE_ASSIGNMENTS ra

1665: SELECT resource_assignment_id, wbs_element_version_id, budget_version_id, project_structure_version_id
1666: FROM
1667: (
1668: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id
1669: FROM PA_RESOURCE_ASSIGNMENTS ra
1670: ,PA_BUDGET_VERSIONS bv
1671: ,PA_PROJ_ELEM_VER_STRUCTURE evs
1672: -- ,PA_PROJECT_ASSIGNMENTS pa -- 5110598 Removed PA_PROJECT_ASSIGNMENTS table usage
1673: WHERE ra.project_id = bv.project_id

Line 1684: FROM PA_RESOURCE_ASSIGNMENTS ra

1680: AND ra.project_assignment_id = p_assignment_id
1681: AND evs.status_code = 'STRUCTURE_WORKING')
1682: UNION ALL
1683: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id
1684: FROM PA_RESOURCE_ASSIGNMENTS ra
1685: ,PA_BUDGET_VERSIONS bv
1686: ,PA_PROJ_ELEM_VER_STRUCTURE evs
1687: ,PA_PROJ_WORKPLAN_ATTR pwa
1688: -- ,PA_PROJECT_ASSIGNMENTS pa -- 5110598 Removed PA_PROJECT_ASSIGNMENTS table usage