APPS.IGS_CA_VAL_DAI SQL Statements

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

Line: 11

  		SELECT s_cal_cat
  		FROM IGS_CA_TYPE
  		WHERE cal_type = p_cal_type;

Line: 47

  	SELECT	*
  	FROM	IGS_CA_DA_INST_V
  	WHERE	dt_alias = cp_dt_alias
  	AND	sequence_number = cp_sequence_number
  	AND	cal_type = cp_cal_type
  	AND	ci_sequence_number = cp_ci_sequence_number;

Line: 59

  	SELECT	*
  	FROM	IGS_CA_DA_INST_V
  	WHERE	dt_alias = cp_dt_alias
  	AND	sequence_number <> cp_sequence_number
  	AND	cal_type = cp_cal_type
  	AND	ci_sequence_number = cp_ci_sequence_number
  	AND	alias_val IS NOT NULL
  	AND	alias_val = cp_alias_val;

Line: 111

  SELECT 	closed_ind,
  	s_cal_cat
  FROM	IGS_CA_DA
  WHERE	dt_alias = p_dt_alias;

Line: 117

  SELECT 	s_cal_cat
  FROM	IGS_CA_TYPE
  WHERE	cal_type = p_cal_type;