APPS.PA_PURGE_VALIDATE_PJRM dependencies on PA_PROJECT_ASSIGNMENTS

Line 51: from pa_project_assignments pa

47:
48: select 'Assignment or Requirement Exists' , 'PA_ARPR_ASG_REQ_EXISTS'
49: from dual
50: where exists ( select NULL
51: from pa_project_assignments pa
52: where nvl(pa.project_id, 0) = p_project_id
53: )
54: UNION
55: select 'Administrative or Unassigned Time Type' , 'PA_ARPR_ADM_UNASS_PRJ_TYP'

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 286: FROM Pa_project_assignments pa

282: Dates are compared with project Closed Date*/
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'