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_PROJECT_UTILS dependencies on PA_ASSIGNMENTS_HISTORY

Line 867: FROM pa_project_assignments ppa, pa_assignments_history pph, pa_project_statuses pps, pa_project_statuses pps1

863: AND ppa.status_code = pps.project_status_code
864: AND pps.project_system_status_code = 'STAFFED_ASGMT_CONF'
865: UNION
866: SELECT 'N'
867: FROM pa_project_assignments ppa, pa_assignments_history pph, pa_project_statuses pps, pa_project_statuses pps1
868: WHERE ppa.project_id = l_project_id
869: AND ppa.assignment_id = pph.assignment_id
870: AND ppa.assignment_type = 'STAFFED_ASSIGNMENT'
871: -- AND pph.assignment_type = 'STAFFED_ASSIGNMENT' -- Not required since a staffed assignment in present is checked with staffed assignment in the past