APPS.IGS_AS_VAL_EIS SQL Statements

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

Line: 25

  		SELECT	'x'
  		FROM	IGS_EN_STDNT_PS_ATT 		sca
  		WHERE	sca.person_id			= cp_person_id AND
  			sca.course_attempt_status	IN (cst_enrolled, cst_intermit,
  								cst_lapsed, cst_inactive);

Line: 76

  		SELECT	'x'
  		FROM	IGS_AS_EXM_SPRVSRTYP
  		WHERE	exam_supervisor_type	= p_exam_supervisor_type AND
  			in_charge_ind		= 'N';

Line: 82

  		SELECT	count(distinct eis.person_id)
  		FROM	IGS_AS_EXM_INS_SPVSR	eis,
  			IGS_AS_EXM_SUPRVISOR		esu,
  			IGS_AS_EXM_SPRVSRTYP	est
  		WHERE	eis.person_id			<> p_person_id			AND
  			eis.exam_cal_type		= p_exam_cal_type		AND
  			eis.exam_ci_sequence_number	= p_exam_ci_sequence_number	AND
  			eis.dt_alias			= p_dt_alias			AND
  			eis.dai_sequence_number		= p_dai_sequence_number		AND
  			IGS_GE_GEN_003.GENP_SET_TIME(eis.start_time)	= v_start_time			AND
  			IGS_GE_GEN_003.GENP_SET_TIME(eis.end_time)	= v_end_time			AND
  			eis.venue_cd			= p_venue_cd			AND
  			eis.person_id			= esu.person_id			AND
  			esu.exam_supervisor_type	= est.exam_supervisor_type	AND
  			est.in_charge_ind		= 'Y';

Line: 98

  		SELECT	count(esvs.person_id)
  		FROM	IGS_AS_EXM_SES_VN_SP	esvs,
  			IGS_AS_EXM_SUPRVISOR			esu,
  			IGS_AS_EXM_SPRVSRTYP		est
  		WHERE	esvs.person_id			<> p_person_id			AND
  			esvs.exam_cal_type		= p_exam_cal_type		AND
  			esvs.exam_ci_sequence_number	= p_exam_ci_sequence_number 	AND
  			esvs.dt_alias			= p_dt_alias			AND
  			esvs.dai_sequence_number	= p_dai_sequence_number 	AND
  			IGS_GE_GEN_003.GENP_SET_TIME(esvs.start_time)	= v_start_time			AND
  			IGS_GE_GEN_003.GENP_SET_TIME(esvs.end_time)	= v_end_time			AND
  			esvs.venue_cd			= p_venue_cd			AND
  			esvs.person_id			= esu.person_id			AND
  			esu.exam_supervisor_type	= est.exam_supervisor_type 	AND
  			est.in_charge_ind	= 'Y';

Line: 179

  		SELECT 	est.in_charge_ind
  		FROM 	IGS_AS_EXM_SUPRVISOR		esu,
  			IGS_AS_EXM_SPRVSRTYP	est
  		WHERE 	esu.person_id			= p_person_id	AND
  			esu.exam_supervisor_type	= est.exam_supervisor_type;

Line: 185

  		SELECT	est.in_charge_ind
  		FROM	IGS_AS_EXM_SPRVSRTYP	est
  		WHERE	exam_supervisor_type	= p_exam_supervisor_type;

Line: 191

  	--Select the persons current type and in_charge indicator
  	OPEN c_est;

Line: 195

  	--Select the in-charge indicator of the exam_supervisor_type that will be
  	-- used to overide the persons current type
  	OPEN c_est2;

Line: 248

  		SELECT	COUNT(DISTINCT person_id)
  		FROM	IGS_AS_EXM_INS_SPVSR
  		WHERE	exam_cal_type 		= p_exam_cal_type	AND
  			exam_ci_sequence_number	= p_exam_ci_sequence_number 	AND
  			dt_alias		= p_dt_alias		AND
  			dai_sequence_number	= p_dai_sequence_number	AND
  			IGS_GE_GEN_003.GENP_SET_TIME(start_time) = cp_start_time	AND
  			IGS_GE_GEN_003.GENP_SET_TIME(end_time) = cp_end_time		AND
  			venue_cd 		= p_venue_cd;

Line: 260

  		SELECT	COUNT(person_id) -- v_venue_count
  		FROM	IGS_AS_EXM_SES_VN_SP
  		WHERE	exam_cal_type 		= p_exam_cal_type	AND
  			exam_ci_sequence_number	= p_exam_ci_sequence_number 	AND
  			dt_alias		= p_dt_alias		AND
  			dai_sequence_number	= p_dai_sequence_number	AND
  			IGS_GE_GEN_003.GENP_SET_TIME(start_time) = cp_start_time	AND
  			IGS_GE_GEN_003.GENP_SET_TIME(end_time) = cp_end_time		AND
  			venue_cd		= p_venue_cd;

Line: 270

  		SELECT	supervisor_limit
  		FROM	IGS_GR_VENUE
  		WHERE	venue_cd = p_venue_cd;

Line: 303

  	-- Note: If the selected limit is NULL then no limit exists.
  	IF v_supervisor_count > NVL(v_supervisor_limit, v_supervisor_count) THEN
  		P_MESSAGE_NAME := 'IGS_AS_SUPV_LIMIT_EXCEEDS';