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 250: FROM pa_project_assignments

246: l_total_weightings NUMBER := 0;
247:
248: CURSOR get_requirement_details IS
249: SELECT min_resource_job_level, max_resource_job_level, competence_match_weighting, availability_match_weighting, job_level_match_weighting
250: FROM pa_project_assignments
251: WHERE assignment_id = p_assignment_id;
252:
253: BEGIN
254:

Line 421: pa_project_assignments asmt,

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

Line 453: pa_project_assignments asmt,

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

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

467:
468: /* --------------------------------------------------------------------
469: FUNCTION: Update_No_Of_Active_Candidates
470: PURPOSE: This API updates the no_of_active_candidates column in the
471: pa_project_assignments table. It will be called when the user
472: changes the duration for the requirements.
473: -------------------------------------------------------------------- */
474: PROCEDURE Update_No_Of_Active_Candidates (p_assignment_id IN NUMBER,
475: x_return_status OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 489: pa_project_assignments asmt,

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

Line 507: FROM pa_project_assignments

503: AND res.schedulable_flag = 'Y';
504:
505: SELECT record_version_number
506: INTO l_record_version_number
507: FROM pa_project_assignments
508: WHERE assignment_id = p_assignment_id;
509:
510: pa_project_assignments_pkg.Update_row(
511: p_assignment_id => p_assignment_id,

Line 510: pa_project_assignments_pkg.Update_row(

506: INTO l_record_version_number
507: FROM pa_project_assignments
508: WHERE assignment_id = p_assignment_id;
509:
510: pa_project_assignments_pkg.Update_row(
511: p_assignment_id => p_assignment_id,
512: p_no_of_active_candidates => l_no_of_active_candidates,
513: p_record_version_number => l_record_version_number,
514: x_return_status => l_return_status );