APPS.PA_PURGE_VALIDATE_PJRM dependencies on PA_PROJECTS

Line 59: pa_projects_all p

55: select 'Administrative or Unassigned Time Type' , 'PA_ARPR_ADM_UNASS_PRJ_TYP'
56: from dual
57: where exists ( select pt.project_type
58: from pa_project_types_all pt,
59: pa_projects_all p
60: where p.project_id = p_project_id
61: and pt.project_type = p.project_type
62: and ( nvl(pt.administrative_flag, 'N') = 'Y'
63: or nvl(pt.unassigned_time, 'N') = 'Y' ));

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 288: , pa_projects pr

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
292: AND pa.status_code = ps.project_status_code

Line 388: l_project_status PA_PROJECTS_ALL.project_status_code%TYPE;

384:
385: l_count NUMBER := -1;
386: l_install VARCHAR2(1);
387: l_start_date DATE;
388: l_project_status PA_PROJECTS_ALL.project_status_code%TYPE;
389: l_count_fnd NUMBER := 0;
390: l_count_drv NUMBER := 0;
391: l_count_cdl NUMBER := 0;
392: l_count_inv NUMBER := 0;

Line 479: FROM pa_projects_all

475: EXECUTE IMMEDIATE l_string INTO l_start_date;
476:
477: SELECT project_status_code
478: INTO l_project_status
479: FROM pa_projects_all
480: WHERE project_id = p_project_id;
481:
482: IF nvl(p_project_end_date, l_start_date ) >= l_start_date
483: AND PA_PROJECT_UTILS.check_prj_stus_action_allowed(l_project_status, 'STATUS_REPORTING') = 'Y' THEN

Line 533: from pa_projects_all

529: x_err_stage IN OUT NOCOPY VARCHAR2 ) IS --File.Sql.39 bug 4440895
530: cursor chk_pji_migrated IS
531: SELECT 1 from dual
532: where exists (select 1
533: from pa_projects_all
534: where project_id=p_project_id
535: and pji_source_flag='Y');
536: l_count_migrated NUMBER :=0;
537: l_err_stack VARCHAR2(2000);