1607: BEGIN
1608:
1609: SELECT 'Y'
1610: INTO l_timecard_exists
1611: FROM hxc_timecard_summary
1612: WHERE resource_id = p_person_id
1613: AND trunc(start_time) = trunc(p_start_date)
1614: AND trunc(stop_time) = trunc(p_end_date);
1615:
1767: BEGIN
1768:
1769: SELECT 'Y'
1770: INTO l_timecard_exists
1771: FROM hxc_timecard_summary
1772: WHERE resource_id = l_person_id
1773: AND trunc(start_time) = trunc(l_start_date)
1774: AND trunc(stop_time) = trunc(l_end_date);
1775: