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 490: pa_resources_denorm res,

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