32: p_stop_time IN DATE)
33: IS
34:
35: select '1' 36: from hxc_locks 37: where resource_id = p_resource_id
38: and start_time <= p_stop_time
39: and stop_time >= p_start_time
40: and (sysdate - lock_date) < (20/(24*60)); -- Added 20 min max locking period Bug 9014012