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

Line 153: FROM pa_project_assignments pa, pa_project_statuses ps, pa_projects pr

149: Projects.
150:
151: CURSOR CUR_REQUIREMENTS_CLOSED IS
152: SELECT 1
153: FROM pa_project_assignments pa, pa_project_statuses ps, pa_projects pr
154: WHERE pa.assignment_type = 'OPEN_ASSIGNMENT'
155: AND pa.status_code = ps.project_status_code
156: AND ps.status_type='OPEN_ASGMT'
157: AND ps.project_system_status_code ='OPEN_ASGMT'

Line 171: FROM pa_project_assignments pa, pa_project_statuses ps

167: This cursor is applicable for Open Indirect Project Purge.*/
168:
169: CURSOR CUR_REQUIREMENTS_ACTIVE IS
170: SELECT 1
171: FROM pa_project_assignments pa, pa_project_statuses ps
172: WHERE pa.assignment_type = 'OPEN_ASSIGNMENT'
173: AND pa.status_code = ps.project_status_code
174: AND ps.status_type='OPEN_ASGMT'
175: AND ps.project_system_status_code ='OPEN_ASGMT'

Line 287: , pa_project_statuses ps

283:
284: CURSOR CUR_ASSIGNMENTS IS
285: SELECT 1
286: FROM Pa_project_assignments pa
287: , pa_project_statuses ps
288: , pa_projects pr
289: WHERE pa.project_id = P_Project_Id
290: AND pa.assignment_type <>'OPEN_ASSIGNMENT'
291: AND nvl(p_txn_to_date,Pr.CLOSED_DATE) < pa.end_date