APPS.HXC_ABS_INTG_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 22

select '1'
from	hxc_timecard_summary
where	resource_id = p_resource_id
  and   start_time <= p_stop_time
  and	stop_time >= p_start_time;

Line: 35

select '1'
from	hxc_locks
where	resource_id = p_resource_id
  and	start_time <= p_stop_time
  and	stop_time >= p_start_time
  and   (sysdate - lock_date) < (20/(24*60)); -- Added 20 min max locking period Bug 9014012

Line: 148

select 1
  from hxc_absence_type_elements
 where absence_attendance_type_id = p_abs_att_id;