APPS.IGS_AS_VAL_ESVS SQL Statements

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

Line: 32

  		SELECT	'1',ei.start_time,ei.end_time
  		FROM	IGS_AS_EXAM_INSTANCE ei
  		WHERE	ei.exam_cal_type 		= p_exam_cal_type AND
  			ei.exam_ci_sequence_number 	= p_exam_ci_sequence_number AND
  			ei.dt_alias			= p_dt_alias AND
  			ei.dai_sequence_number		= p_dai_sequence_number	AND
  			ei.venue_cd 		  	= p_venue_cd;

Line: 85

  		SELECT 	'X'
  		FROM 	IGS_AS_EXM_LOC_SPVSR	els,
  			IGS_GR_VENUE			ve
  		WHERE 	els.person_id		= p_person_id		AND
  			els.exam_location_cd	= ve.exam_location_cd	AND
  			ve.venue_cd		= p_venue_cd;

Line: 138

  		SELECT 	exam_location_cd
  		FROM	IGS_GR_VENUE
  		WHERE	venue_cd = p_venue_cd;

Line: 144

  		SELECT	'x'
  		FROM	IGS_AS_EXM_INS_SPVSR 	eis,
  			IGS_GR_VENUE 			ve
  		WHERE	eis.person_id 	= p_person_id		AND
  			IGS_CA_GEN_001.CALP_GET_ALIAS_VAL(
  					eis.dt_alias,
  					eis.dai_sequence_number,
  					eis.exam_cal_type,
  					eis.exam_ci_sequence_number) = cp_dt_alias_val AND
  			eis.venue_cd 	= ve.venue_cd 				AND
  			ve.exam_location_cd <> cp_exam_location_cd;

Line: 158

  		SELECT	'x'
  		FROM	IGS_AS_EXM_SES_VN_SP 	esvs,
  			IGS_GR_VENUE 				ve
  		WHERE	esvs.person_id 	= p_person_id			AND
  			IGS_CA_GEN_001.CALP_GET_ALIAS_VAL(
  					esvs.dt_alias,
  					esvs.dai_sequence_number,
  					esvs.exam_cal_type,
  					esvs.exam_ci_sequence_number) = cp_dt_alias_val AND
  			esvs.venue_cd 	= ve.venue_cd			AND
  			ve.exam_location_cd <> cp_exam_location_cd;

Line: 245

  		SELECT	'X'
  		FROM	IGS_AS_EXM_INS_SPVSR	eis
  		WHERE	person_id			= p_person_id		AND
  			IGS_CA_GEN_001.CALP_GET_ALIAS_VAL(
  				dt_alias,
  				dai_sequence_number,
  				exam_cal_type,
  				exam_ci_sequence_number) = v_dt_alias_val	AND
   				((Igs_Ge_Gen_003.GENP_SET_TIME(NVL(override_start_time, start_time))
  					BETWEEN v_start_time AND v_end_time OR
  				(Igs_Ge_Gen_003.GENP_SET_TIME( NVL(override_end_time, end_time))
  					BETWEEN  v_start_time AND v_end_time)) OR
  				(Igs_Ge_Gen_003.GENP_SET_TIME( NVL(override_start_time, start_time)) 	<= v_start_time AND
  				Igs_Ge_Gen_003.GENP_SET_TIME( NVL(override_end_time, end_time)) 	>= v_end_time)) AND
  				venue_cd 						<> p_venue_cd;

Line: 261

  		SELECT	'X'
  		FROM	IGS_AS_EXM_SES_VN_SP	esvs
  		WHERE	person_id			= p_person_id		AND
  			IGS_CA_GEN_001.CALP_GET_ALIAS_VAL(
  				dt_alias,
  				dai_sequence_number,
  				exam_cal_type,
  				exam_ci_sequence_number) = v_dt_alias_val	AND
   				((Igs_Ge_Gen_003.GENP_SET_TIME(NVL(override_start_time, start_time))
  					BETWEEN v_start_time AND v_end_time OR
  				(Igs_Ge_Gen_003.GENP_SET_TIME( NVL(override_end_time, end_time))
  					BETWEEN  v_start_time AND v_end_time)) OR
  				(Igs_Ge_Gen_003.GENP_SET_TIME( NVL(override_start_time, start_time)) 	<= v_start_time AND
  				Igs_Ge_Gen_003.GENP_SET_TIME( NVL(override_end_time, end_time)) 	>= v_end_time)) AND
  				venue_cd 						<> p_venue_cd;