APPS.PA_RES_MANAGEMENT_AMG_PUB dependencies on PA_CANDIDATES

Line 12487: -- Reference : pa_candidates.candidate_id

12483: -- Table of candidate records. Please see the CANDIDATE_IN_TBL_TYPE datatype table.
12484: -- OUT :
12485: -- x_candidate_id_tbl OUT SYSTEM.PA_NUM_TBL_TYPE
12486: -- Table to store the candidate ids created by the API.
12487: -- Reference : pa_candidates.candidate_id
12488: -- x_return_status OUT VARCHAR2
12489: -- Indicates the return status of the API.
12490: -- Valid values are: 'S' for Success, 'E' for Error, 'U' for Unexpected Error
12491: -- x_msg_count OUT NUMBER

Line 12577: FROM pa_candidates

12573: WHERE user_id = c_user_id;
12574:
12575: CURSOR c_get_candidate_id(c_assignment_id NUMBER, c_resource_id NUMBER) IS
12576: SELECT candidate_id
12577: FROM pa_candidates
12578: WHERE assignment_id = c_assignment_id
12579: AND resource_id = c_resource_id;
12580:
12581: BEGIN

Line 13173: FROM pa_candidates

13169: AND assignment_type = 'OPEN_ASSIGNMENT';
13170:
13171: CURSOR c_get_candidate_details(c_candidate_id NUMBER) IS
13172: SELECT candidate_id, status_code, candidate_ranking, record_version_number, assignment_id
13173: FROM pa_candidates
13174: WHERE candidate_id = c_candidate_id;
13175:
13176: l_cand_rec c_get_candidate_details%ROWTYPE;
13177:

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