APPS.IGS_GR_VAL_CRDP SQL Statements

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

Line: 14

  		SELECT	'x'
  		FROM	IGS_GR_CRMN_ROUND		crd,
  			IGS_CA_DA_INST_V	daiv
  		WHERE	crd.grd_cal_type  		= p_grd_cal_type AND
  			crd.grd_ci_sequence_number 	= p_grd_ci_sequence_number AND
  			crd.end_dt_alias 		= daiv.dt_alias AND
  			crd.end_dai_sequence_number 	= daiv.sequence_number AND
  			crd.grd_cal_type  		= daiv.cal_type AND
  			crd.grd_ci_sequence_number 	= daiv.ci_sequence_number AND
  			TRUNC(daiv.alias_val) 		< TRUNC(SYSDATE);

Line: 25

  		SELECT	'x'
  		FROM	IGS_GR_CRMN_ROUND		crd,
  			IGS_CA_DA_INST_V	daiv
  		WHERE	crd.grd_cal_type  		= p_grd_cal_type AND
  			crd.grd_ci_sequence_number 	= p_grd_ci_sequence_number AND
  			crd.start_dt_alias 		= daiv.dt_alias AND
  			crd.start_dai_sequence_number 	= daiv.sequence_number AND
  			crd.grd_cal_type  		= daiv.cal_type AND
  			crd.grd_ci_sequence_number 	= daiv.ci_sequence_number AND
  			TRUNC(daiv.alias_val) 		< TRUNC(SYSDATE);