APPS.PA_PURGE_VALIDATE_ICIP dependencies on PA_PROJECTS_ALL

Line 548: l_project_status_code pa_projects_all.project_status_code%TYPE;

544: l_err_stack_old VARCHAR2(2000);
545: l_err_stack VARCHAR2(2000);
546: l_err_stage VARCHAR2(500);
547:
548: l_project_status_code pa_projects_all.project_status_code%TYPE;
549:
550: l_old_err_stage VARCHAR2(500);
551: l_old_err_code number;
552:

Line 569: from pa_projects_all

565: FOR c_prvdr_prj_rec in c_provider_projects LOOP
566:
567: select project_status_code
568: into l_project_status_code
569: from pa_projects_all
570: where project_id = c_prvdr_prj_rec.project_id;
571:
572: if pa_project_stus_utils.is_project_in_purge_status( l_project_status_code ) <> 'Y' then
573: