APPS.IGS_CA_VAL_DAIP SQL Statements

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

Line: 22

  		SELECT	alias_val
  		FROM	IGS_CA_DA_INST_V daiv
  		WHERE	daiv.dt_alias 		= p_dt_alias AND
  			daiv.sequence_number 	= p_dai_sequence_number AND
  			daiv.cal_type 		= p_cal_type AND
  			daiv.ci_sequence_number = p_ci_sequence_number;

Line: 29

  		SELECT	alias_val
  		FROM	IGS_CA_DA_INST_V daiv
  		WHERE	daiv.dt_alias 		= p_related_dt_alias AND
  			daiv.sequence_number 	= p_related_dai_sequence_number AND
  			daiv.cal_type 		= p_related_cal_type AND
  			daiv.ci_sequence_number = p_related_ci_sequence_number;

Line: 155

  		SELECT	'x'
  		FROM	IGS_CA_DA_INST_PAIR daip
  		WHERE	daip.dt_alias 			= p_dt_alias AND
  			daip.dai_sequence_number 	= p_dai_sequence_number AND
  			daip.cal_type 			= p_cal_type AND
  			daip.ci_sequence_number 	= p_ci_sequence_number AND
  			(daip.related_dt_alias 		<> p_related_dt_alias OR
  			daip.related_dai_sequence_number <>  p_related_dai_sequence_number OR
  			daip.related_cal_type 		<> p_related_cal_type OR
  			daip.related_ci_sequence_number <> p_related_ci_sequence_number);