APPS.HXC_TIME_CATEGORY_UTILS_PKG dependencies on PER_PERIODS_OF_SERVICE

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

4972: WHERE tbb.time_building_block_id = p_tc_bbid
4973: AND tbb.object_version_number = p_tc_ovnid;
4974:
4975: cursor emp_hire_info(p_resource_id hxc_time_building_blocks.resource_id%TYPE) IS
4976: select date_start from per_periods_of_service where person_id=p_resource_id order by date_start desc;
4977: /* end of bug fix for 5526281 */
4978:
4979: l_timecard_hrs NUMBER := 0;
4980: l_time_category_id hxc_time_categories.time_category_id%TYPE;