APPS.HXC_TIME_CATEGORY_UTILS_PKG dependencies on PER_PERIODS_OF_SERVICE

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

4855: WHERE tbb.time_building_block_id = p_tc_bbid
4856: AND tbb.object_version_number = p_tc_ovnid;
4857:
4858: cursor emp_hire_info(p_resource_id hxc_time_building_blocks.resource_id%TYPE) IS
4859: select date_start from per_periods_of_service where person_id=p_resource_id order by date_start desc;
4860: /* end of bug fix for 5526281 */
4861:
4862: l_timecard_hrs NUMBER := 0;
4863: l_time_category_id hxc_time_categories.time_category_id%TYPE;