APPS.PA_CANDIDATE_PUB dependencies on PA_CANDIDATES_S

Line 406: (PA_CANDIDATES_S.nextval,

402: CREATED_BY,
403: LAST_UPDATE_DATE,
404: LAST_UPDATED_BY)
405: VALUES
406: (PA_CANDIDATES_S.nextval,
407: p_ASSIGNMENT_ID,
408: l_RESOURCE_ID,
409: 1,
410: l_status_code,

Line 2683: (PA_CANDIDATES_S.nextval,

2679: CREATED_BY,
2680: LAST_UPDATE_DATE,
2681: LAST_UPDATED_BY)
2682: VALUES
2683: (PA_CANDIDATES_S.nextval,
2684: p_new_requirement_id,
2685: c2.resource_id,
2686: 1,
2687: c2.status_code,

Line 2887: UPDATE pa_candidates SET

2883: --dbms_output.put_line ('candidate id to be declined: ' || l_candidate_id_tbl(i));
2884: --dbms_output.put_line ('resource id to be declined: ' || l_resource_id_tbl(i));
2885:
2886: -- Added WHO Column update. Bug 7168412.
2887: UPDATE pa_candidates SET
2888: status_code = l_decline_status_code,
2889: record_version_number = l_record_version_number_tbl(i) + 1,
2890: LAST_UPDATE_DATE = SYSDATE,
2891: LAST_UPDATED_BY = FND_GLOBAL.USER_ID