APPS.HXC_TIMECARD dependencies on HXC_LOCKS

Line 1483: FROM hxc_locks loc

1479: -- Commented out the initial query that was written for bug 8422744
1480: /*
1481: SELECT rowidtochar(loc.rowid)
1482: INTO d_lock_rowid
1483: FROM hxc_locks loc
1484: WHERE loc.resource_id = l_resource_id
1485: AND TRUNC(loc.start_time) = TRUNC(l_timecard_start_time)
1486: AND TRUNC(loc.stop_time) = TRUNC(l_timecard_stop_time);
1487: */

Line 1491: FROM hxc_locks loc

1487: */
1488:
1489: SELECT 1
1490: INTO d_exists
1491: FROM hxc_locks loc
1492: WHERE loc.resource_id = l_resource_id
1493: AND TRUNC(loc.start_time) = TRUNC(l_timecard_start_time)
1494: AND TRUNC(loc.stop_time) = TRUNC(l_timecard_stop_time)
1495: AND lock_date >= SYSDATE - (1/(48))