APPS.PA_CANDIDATE_UTILS dependencies on PA_RESOURCES_DENORM

Line 63: FROM pa_resources_denorm

59: l_resource_id NUMBER := null;
60: BEGIN
61: SELECT resource_id
62: INTO l_resource_id
63: FROM pa_resources_denorm
64: WHERE person_id = p_person_id and rownum=1;
65:
66: RETURN l_resource_id;
67: EXCEPTION

Line 469: pa_resources_denorm res,

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
473: AND cand.resource_id = res.resource_id