APPS.IGS_AS_VAL_SEI SQL Statements

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

Line: 81

  		SELECT 'x'
  		FROM	IGS_AS_STD_EXM_INSTN
  		WHERE	person_id 		= p_person_id 	AND
  			course_cd 		= p_course_cd 	AND
                        -- anilk, 22-Apr-2003, Bug# 2829262
  			uoo_id          	= p_uoo_id      AND
  			exam_cal_type 		= p_exam_cal_type AND
  			exam_ci_sequence_number = p_exam_ci_sequence_number AND
  			ass_id 			= p_ass_id 	AND
  			(venue_cd 		<> p_venue_cd 		OR
  			dt_alias 		<> p_dt_alias 		OR
  			dai_sequence_number 	<> p_dai_sequence_number OR
  			start_time 		<> p_start_time 	OR
  			end_time 		<> p_end_time);

Line: 145

  		SELECT 		sei.person_id,
  				sei.seat_number
  		FROM		IGS_AS_STD_EXM_INSTN	sei
  		WHERE		sei.ese_id 		= p_ese_id  AND
  				sei.venue_cd		= p_venue_cd AND
  				EXISTS(
  				SELECT	'x'
  				FROM	IGS_AS_STD_EXM_INSTN 	sei2
  				WHERE	sei2.ese_id 		= sei.ese_id  AND
  					sei2.venue_cd		= sei.venue_cd AND
  					sei2.person_id		<> sei.person_id AND
  					sei2.seat_number	= sei.seat_number);