APPS.IGS_PS_VAL_ATL SQL Statements

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

Line: 24

  		SELECT	closed_ind,
  			s_cal_cat
  		FROM	IGS_CA_TYPE
  		WHERE	cal_type = p_cal_type;

Line: 31

  	-- being inserted.
  	p_message_name := NULL;

Line: 78

  		SELECT	lower_enr_load_range,
  			upper_enr_load_range
  		FROM	IGS_EN_ATD_TYPE_LOAD
  		WHERE	cal_type = p_cal_type AND
  			attendance_type <> p_attendance_type AND
  			((p_lower_enr_load_range >= lower_enr_load_range AND
  			p_lower_enr_load_range <= upper_enr_load_range) OR
  			(p_upper_enr_load_range >= lower_enr_load_range AND
  			p_upper_enr_load_range <= upper_enr_load_range) OR
  			(p_lower_enr_load_range < lower_enr_load_range AND
  			p_upper_enr_load_range > upper_enr_load_range));

Line: 127

         SELECT mandatory_flag
         FROM   IGS_GE_REF_CD_TYPE
         WHERE  reference_cd_type = p_reference_type;