APPS.HXC_RETRIEVE_ABSENCES dependencies on PER_PERIODS_OF_SERVICE

Line 2730: select date_start from per_periods_of_service where person_id=p_resource_id order by date_start desc;

2726: l_abs_days NUMBER;
2727: l_abs_hours NUMBER;
2728:
2729: cursor emp_hire_info(p_resource_id hxc_time_building_blocks.resource_id%TYPE) IS
2730: select date_start from per_periods_of_service where person_id=p_resource_id order by date_start desc;
2731:
2732: -- OTL-ABS START
2733:
2734: -- Bug 9019114