APPS.IGS_CA_VAL_DAIO SQL Statements

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

Line: 34

  SELECT 	*
  FROM	IGS_CA_DA_INST_OFST
  WHERE	dt_alias = cp_dt_alias
  AND	dai_sequence_number = cp_dai_sequence_number
  AND	cal_type = cp_cal_type
  AND	ci_sequence_number = cp_ci_sequence_number
  AND	((offset_dt_alias <> p_offset_dt_alias)
  OR	 (offset_dai_sequence_number <> p_offset_dai_sequence_number)
  OR	 (offset_cal_type <> p_offset_cal_type)
  OR	 (offset_ci_sequence_number <> p_offset_ci_sequence_number));

Line: 47

  SELECT	*
  FROM	IGS_CA_INST
  WHERE	cal_type = cp_cal_type and
  	sequence_number = cp_sequence_number;

Line: 53

  SELECT	*
  FROM	IGS_CA_STAT
  WHERE	cal_status = cp_cal_status;

Line: 73

  SELECT 	*
  FROM	IGS_CA_DA_INST_OFST
  WHERE	dt_alias = cp_dt_alias
  AND	dai_sequence_number = cp_dai_sequence_number
  AND	cal_type = cp_cal_type
  AND	ci_sequence_number = cp_ci_sequence_number;

Line: 205

  	SELECT	*
  	FROM	IGS_CA_DA_INST
  	WHERE	dt_alias = p_dt_alias and
  		sequence_number = p_dai_sequence_number and
  		cal_type = p_cal_type and
  		ci_sequence_number = p_ci_sequence_number;

Line: 214

  	SELECT	*
  	FROM	IGS_CA_INST
  	WHERE	cal_type = cp_cal_type and
  		sequence_number = cp_sequence_number;

Line: 220

  	SELECT	*
  	FROM	IGS_CA_STAT
  	WHERE	cal_status = cp_cal_status;