APPS.IGS_EN_VAL_PUE SQL Statements

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

Line: 29

  		SELECT 'x'
  		FROM	IGS_PE_PERS_UNT_EXCL
  		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
  			pue_start_dt		 <>  p_pue_start_dt;

Line: 73

  		SELECT	'x'
  		FROM	IGS_EN_SU_ATTEMPT
  		WHERE	person_id = p_person_id	AND
  			course_cd = p_course_cd	AND
  			unit_cd = p_unit_cd	AND
  			unit_attempt_status = 'ENROLLED';