APPS.PA_RES_MANAGEMENT_AMG_PUB dependencies on PA_CANDIDATES

Line 12485: -- Reference : pa_candidates.candidate_id

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

Line 12575: FROM pa_candidates

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

Line 13152: FROM pa_candidates

13148: AND assignment_type = 'OPEN_ASSIGNMENT';
13149:
13150: CURSOR c_get_candidate_details(c_candidate_id NUMBER) IS
13151: SELECT candidate_id, status_code, candidate_ranking, record_version_number, assignment_id
13152: FROM pa_candidates
13153: WHERE candidate_id = c_candidate_id;
13154:
13155: l_cand_rec c_get_candidate_details%ROWTYPE;
13156:

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