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_PURGE_PJR_TXNS dependencies on PA_PROJECT_STATUSES

Line 45: FROM pa_project_assignments pa, pa_project_statuses ps

41: applicable for open indirect project purge.*/
42:
43: CURSOR CUR_REQUIREMENTS_ACTIVE IS
44: SELECT pa.assignment_id
45: FROM pa_project_assignments pa, pa_project_statuses ps
46: WHERE pa.assignment_type = 'OPEN_ASSIGNMENT'
47: AND pa.status_code = ps.project_status_code
48: AND ps.status_type='OPEN_ASGMT'
49: AND ps.project_system_status_code <> 'OPEN_ASGMT'

Line 53: From pa_project_assignments pa1,pa_project_statuses pps

49: AND ps.project_system_status_code <> 'OPEN_ASGMT'
50: AND pa.project_id = P_PROJECT_ID
51: AND pa.end_date <= P_txn_to_date
52: AND NOT EXISTS (Select NULL
53: From pa_project_assignments pa1,pa_project_statuses pps
54: where pa1.source_assignment_id=pa.assignment_id
55: AND pa1.end_date >P_txn_to_date
56: AND pa1.status_code = pps.project_status_code
57: AND pps.status_type = 'STAFFED_ASGMT'