APPS.HR_EX_EMPLOYEE_INTERNAL dependencies on PER_ALL_ASSIGNMENTS_F
Line 373: from per_all_assignments_f asg
369: -- hr_assignment_internal package . (while terminating the person a new record with atd + 1 will be
370: -- created and then deleted when atd=fpd )
371: cursor csr_get_asg_end_date(p_fpd_date1 date) is
372: select max(asg.effective_end_date) 373: from per_all_assignments_f asg 374: where asg.period_of_service_id = p_period_of_service_id
375: and asg.effective_start_date > p_fpd_date1;
376: l_max_asg_date1 date;
377: -- end of bug6892097