APPS.IGS_AS_VAL_ESE SQL Statements

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

Line: 20

  		SELECT	dt_alias,
  			dai_sequence_number,
  			start_time,
  			end_time,
  			exam_session_number
  		FROM	IGS_AS_EXAM_SESSION es
  		WHERE	exam_cal_type 		= p_exam_cal_type AND
  			exam_ci_sequence_number = p_exam_ci_sequence_number;

Line: 34

  		SELECT	'x'
  		FROM	IGS_AS_EXAM_SESSION es
  		WHERE	es.exam_cal_type 		= p_exam_cal_type 		AND
  			es.exam_ci_sequence_number 	= p_exam_ci_sequence_number 	AND
  			(dt_alias <> cp_dt_alias 			OR
  			 dai_sequence_number <> cp_dai_sequence_number	OR
  			 start_time <> cp_start_time			OR
  			 end_time <> cp_end_time) AND
  			exam_session_number = cp_exam_session_number;

Line: 93

  		SELECT	daiv.alias_val
  		FROM	IGS_CA_DA_INST_V		daiv
  		WHERE	daiv.cal_type 			= cp_exam_cal_type AND
  			daiv.ci_sequence_number 	= cp_exam_ci_sequence_number AND
  		     	daiv.dt_alias 			= cp_dt_alias AND
  			daiv.sequence_number		= cp_dai_sequence_number;

Line: 103

  		SELECT	*
  		FROM	IGS_AS_EXAM_SESSION_V			esv
  		WHERE	esv.exam_cal_type		= cp_exam_cal_type AND
  			esv.exam_ci_sequence_number	= cp_exam_ci_sequence_number AND
  			esv.alias_val			= cp_alias_val;

Line: 180

  		SELECT	s_cal_cat
  		FROM	IGS_CA_TYPE
  		WHERE	cal_type = p_cal_type;

Line: 185

  		SELECT	s_cal_status
  		FROM	IGS_CA_INST	ci,
  			IGS_CA_STAT	cs
  		WHERE	ci.cal_type		= p_cal_type	AND
  			ci.sequence_number	= p_sequence_number AND
  			cs.cal_status		= ci.cal_status;