APPS.SSPWSMED_PKG SQL Statements

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

Line: 32

					       update evidence_status to
					       SUPERCEDED from CURRENT.

  */

  PROCEDURE get_medical_sequence (p_medical_id in out number) is
    cursor c1 is
      select ssp_medicals_s.nextval
      from sys.dual;

Line: 53

      select h.rowid
      from   ssp_medicals h
      where  h.maternity_id = p_maternity_id
	and  h.medical_id <> p_medical_id
	and  upper(h.evidence_source) = p_evidence_source
	and  h.evidence_date = p_evidence_date;

Line: 78

      select h.evidence_source, h.evidence_date
      from   ssp_medicals h
      where  h.absence_attendance_id = p_absence_attendance_id
	and  h.medical_id <> p_medical_id
	and  upper(h.evidence_source) = p_evidence_source
        and  h.evidence_date = p_evidence_date;

Line: 98

   update ssp_medicals
   set evidence_status='SUPERCEDED'
   where absence_attendance_id = p_absence_attendance_id
     and evidence_status = 'CURRENT';

Line: 106

    update ssp_medicals
    set evidence_status='SUPERCEDED'
    where maternity_id = p_maternity_id
      and evidence_status = 'CURRENT';