DBA Data[Home] [Help]

APPS.PA_HR_UPDATE_API dependencies on PA_PROJECT_ASSIGNMENTS

Line 3046: pa_project_assignments asgmt,

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
3050: and asgmt.assignment_type = 'OPEN_ASSIGNMENT'