DBA Data[Home] [Help]

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