APPS.IGS_EN_VAL_AUS SQL Statements

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

Line: 15

  		SELECT	count(*)
  		FROM	IGS_AD_ADM_UT_STA_GD	ausg
  		WHERE	ausg.administrative_unit_status = p_aus;

Line: 71

  		SELECT  ddcv.offset_cons_type_cd,
  			ddcv.constraint_condition,
  			ddcv.constraint_resolution
  		FROM	IGS_EN_DISC_DL_CONS	 ddcv
  		WHERE	ddcv.offset_cons_type_cd        <>p_offset_cons_type_cd		AND

  			ddcv.non_std_disc_dl_stp_id = p_non_std_disc_dl_stp_id;

Line: 259

  	-- 3. Use a loop to select each existing constraint record and determine if
  	--    the current s_dt_offset_constraint_type clashes with an existing
  	--    s_dt_offset_constraint_type for the same dt_alias/offset_dt_alias.
        -- function has been called from IGS_CA_DA_OFFCNT
  		FOR v_ddcv_rec IN c_ddcv LOOP
  			v_message_name := calpl_val_constraint(
  								p_offset_cons_type_cd,
  								p_constraint_condition,
  								v_ddcv_rec.offset_cons_type_cd,
  								v_ddcv_rec.constraint_condition,
  								v_ddcv_rec.constraint_resolution);

Line: 330

  		SELECT  doscv.offset_cons_type_cd,
  			doscv.constraint_condition,
  			doscv.constraint_resolution
  		FROM	IGS_EN_DL_OFFSET_CONS	 doscv
  		WHERE	doscv.offset_cons_type_cd <> cp_c_offset_cons_type_cd AND
  			doscv.non_std_usec_dls_id = cp_n_non_std_usec_dls_id AND
                        doscv.deadline_type = cp_c_deadline_type;

Line: 518

  	-- 3. Use a loop to select each existing constraint record and determine if
  	--    the current s_dt_offset_constraint_type clashes with an existing
  	--    s_dt_offset_constraint_type
  		-- function has been called from IGS_CA_DA_OFFCNT
  		FOR v_doscv_rec IN c_doscv(p_offset_cons_type_cd,
                                           p_non_std_usec_dls_id,
                                           p_deadline_type)  LOOP
  			v_message_name := calpl_val_constraint(
  								p_offset_cons_type_cd,
  								p_constraint_condition,
  								v_doscv_rec.offset_cons_type_cd,
  								v_doscv_rec.constraint_condition,
  								v_doscv_rec.constraint_resolution);