DBA Data[Home] [Help]

APPS.PA_HR_UPDATE_API dependencies on PA_PROJECT_ASSIGNMENTS

Line 3053: pa_project_assignments asgmt,

3049:
3050: CURSOR get_nominations(l_resource_id IN NUMBER) IS
3051: select cand.candidate_id, cand.record_version_number
3052: from pa_candidates cand,
3053: pa_project_assignments asgmt,
3054: pa_project_statuses ps
3055: where cand.resource_id = l_resource_id
3056: and cand.assignment_id = asgmt.assignment_id
3057: and asgmt.assignment_type = 'OPEN_ASSIGNMENT'