APPS.HXC_FIND_NOTIFY_APRS_PKG dependencies on PER_PERIODS_OF_SERVICE

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

1749: WHERE htl.application_period_id = p_app_per_id
1750: AND tbb.time_building_block_id = htl.timecard_id;
1751:
1752: cursor emp_hire_info(p_resource_id hxc_time_building_blocks.resource_id%TYPE) IS
1753: select date_start from per_periods_of_service where person_id=p_resource_id order by date_start desc;
1754: /* end of bug fix for 5526281 */
1755:
1756: l_tc_rec csr_get_timecard%ROWTYPE;
1757: l_timecard_hrs NUMBER := 0;