APPS.PA_PURGE_VALIDATE_PJRM dependencies on PA_PROJECTS_ALL

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 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);