APPS.PA_CANDIDATE_PUB dependencies on PA_CANDIDATES_S

Line 444: (PA_CANDIDATES_S.nextval,

440: CREATED_BY,
441: LAST_UPDATE_DATE,
442: LAST_UPDATED_BY)
443: VALUES
444: (PA_CANDIDATES_S.nextval,
445: p_ASSIGNMENT_ID,
446: l_RESOURCE_ID,
447: 1,
448: l_status_code,

Line 2946: (PA_CANDIDATES_S.nextval,

2942: CREATED_BY,
2943: LAST_UPDATE_DATE,
2944: LAST_UPDATED_BY)
2945: VALUES
2946: (PA_CANDIDATES_S.nextval,
2947: p_new_requirement_id,
2948: c2.resource_id,
2949: 1,
2950: c2.status_code,

Line 3150: UPDATE pa_candidates SET

3146: --dbms_output.put_line ('candidate id to be declined: ' || l_candidate_id_tbl(i));
3147: --dbms_output.put_line ('resource id to be declined: ' || l_resource_id_tbl(i));
3148:
3149: -- Added WHO Column update. Bug 7168412.
3150: UPDATE pa_candidates SET
3151: status_code = l_decline_status_code,
3152: record_version_number = l_record_version_number_tbl(i) + 1,
3153: LAST_UPDATE_DATE = SYSDATE,
3154: LAST_UPDATED_BY = FND_GLOBAL.USER_ID