APPS.PA_CANDIDATE_UTILS dependencies on PA_PROJECT_ASSIGNMENTS

Line 15: FROM pa_project_assignments

11: l_no_of_active_candidates NUMBER := 0;
12: BEGIN
13: SELECT no_of_active_candidates
14: INTO l_no_of_active_candidates
15: FROM pa_project_assignments
16: WHERE assignment_id = p_assignment_id;
17:
18: IF l_no_of_active_candidates is null THEN
19: RETURN 0;

Line 229: FROM pa_project_assignments

225: l_total_weightings NUMBER := 0;
226:
227: CURSOR get_requirement_details IS
228: SELECT min_resource_job_level, max_resource_job_level, competence_match_weighting, availability_match_weighting, job_level_match_weighting
229: FROM pa_project_assignments
230: WHERE assignment_id = p_assignment_id;
231:
232: BEGIN
233:

Line 400: pa_project_assignments asmt,

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
404: AND can.resource_id = p_resource_id

Line 432: pa_project_assignments asmt,

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
436: AND asmt.assignment_type = 'OPEN_ASSIGNMENT'

Line 450: pa_project_assignments table. It will be called when the user

446:
447: /* --------------------------------------------------------------------
448: FUNCTION: Update_No_Of_Active_Candidates
449: PURPOSE: This API updates the no_of_active_candidates column in the
450: pa_project_assignments table. It will be called when the user
451: changes the duration for the requirements.
452: -------------------------------------------------------------------- */
453: PROCEDURE Update_No_Of_Active_Candidates (p_assignment_id IN NUMBER,
454: x_return_status OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 468: pa_project_assignments asmt,

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
472: AND cand.assignment_id = asmt.assignment_id

Line 486: FROM pa_project_assignments

482: AND res.schedulable_flag = 'Y';
483:
484: SELECT record_version_number
485: INTO l_record_version_number
486: FROM pa_project_assignments
487: WHERE assignment_id = p_assignment_id;
488:
489: pa_project_assignments_pkg.Update_row(
490: p_assignment_id => p_assignment_id,

Line 489: pa_project_assignments_pkg.Update_row(

485: INTO l_record_version_number
486: FROM pa_project_assignments
487: WHERE assignment_id = p_assignment_id;
488:
489: pa_project_assignments_pkg.Update_row(
490: p_assignment_id => p_assignment_id,
491: p_no_of_active_candidates => l_no_of_active_candidates,
492: p_record_version_number => l_record_version_number,
493: x_return_status => l_return_status );