APPS.HXC_TIMECARD_SUMMARY_PKG dependencies on PER_PERIODS_OF_SERVICE

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

58: WHERE tbb.time_building_block_id = p_timecard_id
59: AND tbb.object_version_number = p_timecard_ovn;
60:
61: cursor emp_hire_info(p_resource_id hxc_time_building_blocks.resource_id%TYPE) IS
62: select date_start from per_periods_of_service where person_id=p_resource_id order by date_start desc;
63: /* end of bug fix for 5526281 */
64:
65: l_index number :=1;
66: l_precision varchar2(4);