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 137: FROM pa_candidates

133: record_version_number
134: INTO l_candidate_id,
135: l_candidate_ranking,
136: l_record_version_number
137: FROM pa_candidates
138: WHERE assignment_id = p_assignment_id
139: AND resource_id = p_resource_id;
140: EXCEPTION
141: WHEN NO_DATA_FOUND THEN

Line 399: FROM pa_candidates can,

395: BEGIN
396:
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

Line 431: FROM pa_candidates can,

427: BEGIN
428:
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

Line 467: FROM pa_candidates cand,

463: x_return_status := FND_API.G_RET_STS_SUCCESS;
464:
465: SELECT count(*)
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