DBA Data[Home] [Help]

APPS.PA_CANDIDATE_PUB dependencies on PA_CANDIDATE_REVIEWS_S

Line 1273: PA_CANDIDATE_REVIEWS_S.nextval,

1269: LAST_UPDATE_DATE,
1270: LAST_UPDATED_BY)
1271: VALUES
1272: (
1273: PA_CANDIDATE_REVIEWS_S.nextval,
1274: p_candidate_id,
1275: 1,
1276: p_status_code,
1277: l_reviewer_person_id,

Line 1641: PA_CANDIDATE_REVIEWS_S.nextval,

1637: LAST_UPDATE_DATE,
1638: LAST_UPDATED_BY)
1639: VALUES
1640: (
1641: PA_CANDIDATE_REVIEWS_S.nextval,
1642: p_candidate_id,
1643: 1,
1644: l_status_code,
1645: l_reviewer_person_id,

Line 2978: PA_CANDIDATE_REVIEWS_S.nextval,

2974: LAST_UPDATE_DATE,
2975: LAST_UPDATED_BY)
2976: VALUES
2977: (
2978: PA_CANDIDATE_REVIEWS_S.nextval,
2979: l_new_candidate_id,
2980: 1,
2981: c4.status_code,
2982: c4.reviewer_person_id,

Line 3173: (PA_CANDIDATE_REVIEWS_S.nextval,

3169: CREATED_BY,
3170: LAST_UPDATE_DATE,
3171: LAST_UPDATED_BY)
3172: VALUES
3173: (PA_CANDIDATE_REVIEWS_S.nextval,
3174: l_candidate_id_tbl(i),
3175: 1,
3176: l_decline_status_code,
3177: l_reviewer_person_id,