APPS.SSPWSENT_PKG SQL Statements

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

Line: 14

	select	due_date,
		person_ID,
		matching_date
	from	ssp_maternities MAT
	where	mat.maternity_ID = p_maternity_ID;

Line: 40

      select ABSENCE_CATEGORY,
	     PERSON_ID,
	     SICKNESS_START_DATE,
	     SICKNESS_END_DATE,
	     MATERNITY_ID,
	     SMP_DUE_DATE,
	     LINKED_ABSENCE_ID
      from per_absence_attendances_v
      where ABSENCE_ATTENDANCE_ID = p_absence_id;

Line: 67

select element_type_id
from  pay_element_types_f
where   element_name = p_element_name
and     p_effective_date between effective_start_date
and     effective_end_date;