APPS.PA_CANDIDATE_UTILS dependencies on PA_PROJECT_STATUSES

Line 148: FROM PA_PROJECT_STATUSES

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

Line 401: pa_project_statuses ps

397: SELECT count(*)
398: INTO l_num_nomination
399: FROM pa_candidates can,
400: pa_project_assignments asmt,
401: pa_project_statuses ps
402: WHERE can.assignment_id = asmt.assignment_id
403: AND can.status_code = ps.project_status_code
404: AND can.resource_id = p_resource_id
405: AND asmt.assignment_type = 'OPEN_ASSIGNMENT'

Line 433: pa_project_statuses ps

429: SELECT count(*)
430: INTO l_num_qualifieds
431: FROM pa_candidates can,
432: pa_project_assignments asmt,
433: pa_project_statuses ps
434: WHERE can.assignment_id = asmt.assignment_id
435: AND can.status_code = ps.project_status_code
436: AND asmt.assignment_type = 'OPEN_ASSIGNMENT'
437: AND can.resource_id = p_resource_id

Line 470: pa_project_statuses ps

466: INTO l_no_of_active_candidates
467: FROM pa_candidates cand,
468: pa_project_assignments asmt,
469: pa_resources_denorm res,
470: pa_project_statuses ps
471: WHERE cand.assignment_id = p_assignment_id
472: AND cand.assignment_id = asmt.assignment_id
473: AND cand.resource_id = res.resource_id
474: AND asmt.start_date BETWEEN res.resource_effective_start_date AND