APPS.IGS_EN_VAL_PEN SQL Statements

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

Line: 36

  		SELECT	etde.s_encmb_effect_type
  		FROM	IGS_FI_ENC_DFLT_EFT	etde
  		WHERE	encumbrance_type = p_encumbrance_type;

Line: 122

  		SELECT 	*
  		FROM	IGS_PE_PERS_ENCUMB
  		WHERE	person_id = cp_person_id 		AND
  			encumbrance_type = cp_encumbrance_type 	AND
  			start_dt <> cp_start_dt 		AND
  			expiry_dt IS NULL;

Line: 130

    		SELECT 	*
    		FROM	IGS_FI_ENCMB_TYPE
    		WHERE	encumbrance_type = cp_encumbrance_type 	AND
    			s_encumbrance_cat = 'ADMIN';

Line: 187

  		SELECT	etde.s_encmb_effect_type,
  			seet.encumbrance_level
  		FROM	IGS_FI_ENC_DFLT_EFT etde,
--  			s_encmb_effect_type seet
			IGS_EN_ENCMB_EFCTTYP_V SEET
  		WHERE	etde.encumbrance_type = cp_enc_type AND
  			seet.s_encmb_effect_type = etde.s_encmb_effect_type
  		ORDER BY etde.s_encmb_effect_type ASC;

Line: 277

  			-- the first record selected
  			gv_level := gv_encmb_eff_rec.encumbrance_level;