DBA Data[Home] [Help]

APPS.HXC_RETRIEVE_ABSENCES dependencies on HXC_TIMECARD_SUMMARY

Line 1611: FROM hxc_timecard_summary

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:

Line 1771: FROM hxc_timecard_summary

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: