APPS.HXC_TIMECARD_SUMMARY_PKG dependencies on PER_PERIODS_OF_SERVICE

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

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