APPS.PA_CANDIDATE_UTILS dependencies on PA_CANDIDATES

Line 42: FROM pa_candidates

38: BEGIN
39: SELECT
40: assignment_id
41: BULK COLLECT INTO l_candidate_req_table
42: FROM pa_candidates
43: WHERE resource_id = p_resource_id;
44:
45: RETURN l_candidate_req_table;
46: EXCEPTION

Line 87: from pa_candidates

83: l_exists VARCHAR2(1) := 'N';
84: BEGIN
85: SELECT 'Y'
86: into l_exists
87: from pa_candidates
88: where assignment_id = p_assignment_id
89: and resource_id = p_resource_id;
90:
91: RETURN 'Y';

Line 141: FROM pa_candidates

137: record_version_number
138: INTO l_candidate_id,
139: l_candidate_ranking,
140: l_record_version_number
141: FROM pa_candidates
142: WHERE assignment_id = p_assignment_id
143: AND resource_id = p_resource_id;
144: EXCEPTION
145: WHEN NO_DATA_FOUND THEN

Line 420: FROM pa_candidates can,

416: BEGIN
417:
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

Line 452: FROM pa_candidates can,

448: BEGIN
449:
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

Line 488: FROM pa_candidates cand,

484: x_return_status := FND_API.G_RET_STS_SUCCESS;
485:
486: SELECT count(*)
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