APPS.HXC_FIND_NOTIFY_APRS_PKG dependencies on PER_PERIODS_OF_SERVICE

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

1608: WHERE htl.application_period_id = p_app_per_id
1609: AND tbb.time_building_block_id = htl.timecard_id;
1610:
1611: cursor emp_hire_info(p_resource_id hxc_time_building_blocks.resource_id%TYPE) IS
1612: select date_start from per_periods_of_service where person_id=p_resource_id order by date_start desc;
1613: /* end of bug fix for 5526281 */
1614:
1615: l_tc_rec csr_get_timecard%ROWTYPE;
1616: l_timecard_hrs NUMBER := 0;