DBA Data[Home] [Help]

APPS.PA_RES_MANAGEMENT_AMG_PUB dependencies on PA_CANDIDATES_V

Line 14080: FROM pa_candidates pc, pa_candidates_v pcv

14076: AND lookup_code = c_change_reason_code;
14077:
14078: CURSOR c_get_candidate_details(c_candidate_id NUMBER) IS
14079: SELECT pcv.project_id, pc.assignment_id, pc.record_version_number
14080: FROM pa_candidates pc, pa_candidates_v pcv
14081: WHERE pc.candidate_id = c_candidate_id
14082: AND pcv.candidate_number = c_candidate_id;
14083:
14084: CURSOR c_get_system_status_code(c_status_code VARCHAR2) IS