APPS.IGS_EN_VAL_PUR SQL Statements

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

Line: 29

  		SELECT 'x'
  		FROM	IGS_PE_UNT_REQUIRMNT
  		WHERE
  			person_id		= p_person_id		AND
  			encumbrance_type	= p_encumbrance_type	AND
  			pen_start_dt		= p_pen_start_dt	AND
  			s_encmb_effect_type	= p_s_encmb_effect_type	AND
  			pee_start_dt		= p_pee_start_dt	AND
  			unit_cd			= p_unit_cd		AND
  			expiry_dt	IS NULL				AND
  			pur_start_dt		 <>  p_pur_start_dt;