APPS.IGS_EN_VAL_PUSE SQL Statements

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

Line: 25

  		SELECT	'x'
  		FROM	IGS_AS_SU_SETATMPT susa
  		WHERE	susa.person_id = p_person_id	AND
  			susa.course_cd = p_course_cd	AND
  			susa.unit_set_cd = p_unit_set_cd	AND
  			susa.us_version_number = p_us_version_number	AND
  			susa.student_confirmed_ind = 'Y'	AND
  			susa.end_dt IS NULL;

Line: 81

  		SELECT 'x'
  		FROM	IGS_PE_UNT_SET_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_set_cd		= p_unit_set_cd	AND
  			us_version_number	= p_us_version_number	AND
  			expiry_dt	IS NULL				AND
  			puse_start_dt		 <>  p_puse_start_dt;

Line: 124

  		SELECT	us.unit_set_cd
  		FROM	IGS_EN_UNIT_SET us
  		WHERE	us.unit_set_cd    = p_unit_set_cd AND
  			us.version_number = p_version_number;