DBA Data[Home] [Help]

APPS.IGS_EN_VAL_ETDE SQL Statements

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

Line: 14

  		SELECT 	closed_ind
  		FROM	IGS_FI_ENCMB_TYPE
  		WHERE	encumbrance_type = p_encumbrance_type;
Line: 53

  		SELECT 	closed_ind
  		FROM	IGS_EN_ENCMB_EFCTTYP_V
  		WHERE	s_encmb_effect_type = p_s_encmb_effect_type;
Line: 96

  		SELECT	pot.s_progression_outcome_type
  		FROM	IGS_PR_OU_TYPE 	pot
  		WHERE	NVL(pot.encumbrance_type,' ')	= p_encumbrance_type;