APPS.PA_HR_UPDATE_API dependencies on PA_R_PROJECT_RESOURCES_TERM_V

Line 3224: from pa_r_project_resources_term_v res

3220: where res.person_id = p_person_id
3221: and res.assignment_end_date IS NOT NULL
3222: UNION
3223: select max(res.assignment_end_date) ass_end_date
3224: from pa_r_project_resources_term_v res
3225: where res.person_id = p_person_id
3226: and res.assignment_end_date IS NOT NULL );
3227:
3228: l_end_date DATE;