APPS.IGS_GR_VAL_GC SQL Statements

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

Line: 23

  		SELECT	'X'
  		FROM	IGS_CA_DA_INST_V 		daiv
	   	WHERE	daiv.dt_alias 		= p_ceremony_dt_alias AND
  			daiv.sequence_number 	= p_ceremony_dai_sequence_number AND
  			daiv.cal_type 		= p_grd_cal_type AND
  			daiv.ci_sequence_number 	= p_grd_ci_sequence_number AND
  			TRUNC(daiv.alias_val)	< TRUNC(SYSDATE);

Line: 31

  		SELECT	'X'
  		FROM	IGS_CA_DA_INST_V 		daiv
  		WHERE	daiv.dt_alias 		= p_closing_dt_alias AND
  			daiv.sequence_number 	= p_closing_dai_sequence_number AND
  			daiv.cal_type 		= p_grd_cal_type AND
  			daiv.ci_sequence_number 	= p_grd_ci_sequence_number AND
  			TRUNC(daiv.alias_val)	< TRUNC(SYSDATE);

Line: 39

  		SELECT	'X'
  		FROM	IGS_CA_DA_INST_V 		ceremony_daiv,
  			IGS_CA_DA_INST_V 		closing_daiv
  		WHERE	ceremony_daiv.dt_alias 		= p_ceremony_dt_alias AND
  			ceremony_daiv.sequence_number 	= p_ceremony_dai_sequence_number AND
  			ceremony_daiv.cal_type 		= p_grd_cal_type AND
  			ceremony_daiv.ci_sequence_number 	= p_grd_ci_sequence_number AND
  			closing_daiv.dt_alias 		= p_closing_dt_alias AND
  			closing_daiv.sequence_number 	= p_closing_dai_sequence_number AND
  			closing_daiv.cal_type 		= p_grd_cal_type AND
  			closing_daiv.ci_sequence_number 	= p_grd_ci_sequence_number AND
  			closing_daiv.alias_val 		<= ceremony_daiv.alias_val;

Line: 123

  		SELECT	'X'
  		FROM	IGS_GR_AWD_CRMN		gac
  		WHERE	gac.grd_cal_type		= p_grd_cal_type AND
  			gac.grd_ci_sequence_number	= p_grd_ci_sequence_number AND
  			gac.ceremony_number		= p_ceremony_number;

Line: 169

  		SELECT	'x'
  		FROM	IGS_GR_CRM_ROUND_PRD crdp
  		WHERE	crdp.grd_cal_type		= p_grd_cal_type AND
  			crdp.grd_ci_sequence_number	= p_grd_ci_sequence_number;

Line: 227

  		SELECT	'x'
  		FROM	IGS_GR_CRMN	gc,
  			IGS_CA_DA_INST_V	daiv1,
  			IGS_CA_DA_INST_V	daiv2
  		WHERE	gc.grd_cal_type			= p_grd_cal_type			AND
  			gc.grd_ci_sequence_number	= p_grd_ci_sequence_number		AND
  			gc.ceremony_number		<> p_ceremony_number			AND
  			gc.venue_cd			= p_venue_cd				AND
  			gc.ceremony_dt_alias		= daiv1.dt_alias			AND
  			gc.ceremony_dai_sequence_number	= daiv1.sequence_number			AND
  			gc.grd_cal_type			= daiv1.cal_type			AND
  			gc.grd_ci_sequence_number	= daiv1.ci_sequence_number		AND
  			daiv2.dt_alias			= p_ceremony_dt_alias			AND
  			daiv2.sequence_number		= p_ceremony_dai_sequence_number	AND
  			daiv2.cal_type			= p_grd_cal_type			AND
  			daiv2.ci_sequence_number	= p_grd_ci_sequence_number		AND
  			TRUNC(daiv1.alias_val)		= TRUNC(daiv2.alias_val)		AND
  			((TO_CHAR(p_ceremony_start_time, 'HH24:MI') >
  				TO_CHAR(gc.ceremony_start_time, 'HH24:MI')		AND
  			TO_CHAR(p_ceremony_start_time, 'HH24:MI') <
  				TO_CHAR(gc.ceremony_end_time, 'HH24:MI'))			OR
  			(TO_CHAR(p_ceremony_end_time, 'HH24:MI') >
  				 TO_CHAR(gc.ceremony_start_time, 'HH24:MI')		AND
  			TO_CHAR(p_ceremony_end_time, 'HH24:MI') <=
  				TO_CHAR(gc.ceremony_end_time, 'HH24:MI'))		OR
  			(TO_CHAR(p_ceremony_start_time, 'HH24:MI') <=
  				TO_CHAR(gc.ceremony_start_time, 'HH24:MI')		AND
  			TO_CHAR(p_ceremony_end_time, 'HH24:MI') >=
  				TO_CHAR(gc.ceremony_end_time, 'HH24:MI')));

Line: 313

  		SELECT	'x'
  		FROM	IGS_GR_CRMN	gc,
  			IGS_CA_DA_INST_V	daiv
  		WHERE	gc.grd_cal_type			= p_grd_cal_type		AND
  			gc.grd_ci_sequence_number	= p_grd_ci_sequence_number	AND
  			gc.ceremony_number		= p_ceremony_number		AND
  			gc.ceremony_dt_alias		= daiv.dt_alias			AND
  			gc.ceremony_dai_sequence_number	= daiv.sequence_number		AND
  			gc.grd_cal_type			= daiv.cal_type			AND
  			gc.grd_ci_sequence_number	= daiv.ci_sequence_number	AND
  			TRUNC(daiv.alias_val)		< TRUNC(SYSDATE);

Line: 371

  		SELECT	'x'
  		FROM	IGS_GR_VENUE		ve,
  			IGS_AD_LOCATION	loc,
  			IGS_AD_LOCATION_TYPE	lot
  		WHERE	ve.venue_cd		= p_venue_cd AND
  			ve.exam_location_cd	= loc.location_cd AND
  			loc.location_type	= lot.location_type AND
  			lot.s_location_type	= cst_grd_ctr;

Line: 419

  		SELECT closed_ind
  		FROM	IGS_GR_VENUE
  		WHERE	venue_cd = p_venue_cd;