DBA Data[Home] [Help]

APPS.PA_HR_UPDATE_API dependencies on PA_CANDIDATES

Line 3045: from pa_candidates cand,

3041: P_DEBUG_MODE VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
3042:
3043: CURSOR get_nominations(l_resource_id IN NUMBER) IS
3044: select cand.candidate_id, cand.record_version_number
3045: from pa_candidates cand,
3046: pa_project_assignments asgmt,
3047: pa_project_statuses ps
3048: where cand.resource_id = l_resource_id
3049: and cand.assignment_id = asgmt.assignment_id