APPS.PA_RES_MANAGEMENT_AMG_PUB dependencies on PA_CANDIDATES_V

Line 14118: FROM pa_candidates pc, pa_candidates_v pcv

14114: AND lookup_code = c_change_reason_code;
14115:
14116: CURSOR c_get_candidate_details(c_candidate_id NUMBER) IS
14117: SELECT pcv.project_id, pc.assignment_id, pc.record_version_number
14118: FROM pa_candidates pc, pa_candidates_v pcv
14119: WHERE pc.candidate_id = c_candidate_id
14120: AND pcv.candidate_number = c_candidate_id;
14121:
14122: CURSOR c_get_system_status_code(c_status_code VARCHAR2) IS