APPS.IGS_EN_VAL_DLA SQL Statements

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

Line: 16

  		SELECT	s_cal_status
  		FROM	IGS_CA_STAT cs,
  			IGS_CA_INST ci
  		WHERE	ci.cal_type = p_cal_type			AND
  			ci.sequence_number = p_ci_sequence_number	AND
  			cs.cal_status = ci.cal_status;

Line: 54

  		SELECT	cal_status
  		FROM	IGS_CA_INST
  		WHERE	cal_type = p_cal_type AND
  			sequence_number = p_ci_sequence;

Line: 59

  		SELECT	s_cal_status
  		FROM	IGS_CA_STAT
  		WHERE	cal_status = cp_cal_status;

Line: 64

  	-- for a IGS_ST_DFT_LOAD_APPO record being inserted.
  	--- Set the default message number
  	p_message_name := null;

Line: 113

  		SELECT	closed_ind,
  			s_cal_cat
  		FROM	IGS_CA_TYPE
  		WHERE	cal_type = p_cal_type;

Line: 120

  	-- IGS_ST_DFT_LOAD_APPO record being inserted with each cal_type.
  	--- Set the default message number
  	p_message_name := null;

Line: 165

  		SELECT	closed_ind,
  			s_cal_cat
  		FROM	IGS_CA_TYPE
  		WHERE	cal_type = p_cal_type;

Line: 172

  	-- IGS_ST_DFT_LOAD_APPO record being inserted with each
  	-- teach_cal_type.
  	--- Set the default message number
  	p_message_name := null;