APPS.PA_CANDIDATE_UTILS dependencies on PA_PROJECT_STATUSES

Line 152: FROM PA_PROJECT_STATUSES

148: END;
149:
150: SELECT project_status_code
151: INTO l_project_status_code
152: FROM PA_PROJECT_STATUSES
153: WHERE project_system_status_code = 'CANDIDATE_PENDING_REVIEW'
154: AND PREDEFINED_FLAG = 'Y' -- Added for bug 5222893
155: AND status_type = 'CANDIDATE'; -- Bug 4773033 CANDIDATE ROUTINES JOIN FOR PROJECT STATUSES
156:

Line 422: pa_project_statuses ps

418: SELECT count(*)
419: INTO l_num_nomination
420: FROM pa_candidates can,
421: pa_project_assignments asmt,
422: pa_project_statuses ps
423: WHERE can.assignment_id = asmt.assignment_id
424: AND can.status_code = ps.project_status_code
425: AND can.resource_id = p_resource_id
426: AND asmt.assignment_type = 'OPEN_ASSIGNMENT'

Line 454: pa_project_statuses ps

450: SELECT count(*)
451: INTO l_num_qualifieds
452: FROM pa_candidates can,
453: pa_project_assignments asmt,
454: pa_project_statuses ps
455: WHERE can.assignment_id = asmt.assignment_id
456: AND can.status_code = ps.project_status_code
457: AND asmt.assignment_type = 'OPEN_ASSIGNMENT'
458: AND can.resource_id = p_resource_id

Line 491: pa_project_statuses ps

487: INTO l_no_of_active_candidates
488: FROM pa_candidates cand,
489: pa_project_assignments asmt,
490: pa_resources_denorm res,
491: pa_project_statuses ps
492: WHERE cand.assignment_id = p_assignment_id
493: AND cand.assignment_id = asmt.assignment_id
494: AND cand.resource_id = res.resource_id
495: AND asmt.start_date BETWEEN res.resource_effective_start_date AND