DBA Data[Home] [Help]

APPS.HR_EX_EMPLOYEE_INTERNAL dependencies on PER_ALL_ASSIGNMENTS_F

Line 381: from per_all_assignments_f asg

377: -- hr_assignment_internal package . (while terminating the person a new record with atd + 1 will be
378: -- created and then deleted when atd=fpd )
379: cursor csr_get_asg_end_date(p_fpd_date1 date) is
380: select max(asg.effective_end_date)
381: from per_all_assignments_f asg
382: where asg.period_of_service_id = p_period_of_service_id
383: and asg.effective_start_date > p_fpd_date1;
384: l_max_asg_date1 date;
385: -- end of bug6892097