APPS.IGS_ST_VAL_ESS SQL Statements

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

Line: 19

  		SELECT	eswv_excluded.snapshot_dt_time,
  			eswv_excluded.ci_cal_type,
  			eswv_excluded.ci_sequence_number,
  			eswv_excluded.person_id,
  			eswv_excluded.course_version,
  			eswv_excluded.unit_version
  		FROM	IGS_EN_ST_SNAPSHOT_WARNING_V	eswv_excluded
  		WHERE	eswv_excluded.snapshot_dt_time	= p_snapshot_dt_time AND
  			eswv_excluded.govt_reportable_ind = 'X';

Line: 39

  		SELECT	'X'
  		FROM	IGS_EN_ST_SNAPSHOT_WARNING_V	eswv_warning
  		WHERE	eswv_warning.snapshot_dt_time 	= cp_snapshot_dt_time AND
  			eswv_warning.ci_cal_type 	= cp_ci_cal_type AND
  			eswv_warning.ci_sequence_number	= cp_ci_sequence_number AND
  			eswv_warning.person_id 		= cp_person_id AND
  			eswv_warning.course_version	= cp_course_version AND
  			eswv_warning.unit_version	= cp_unit_version AND
  			eswv_warning.govt_reportable_ind = 'W';