APPS.IGS_EN_VAL_PCGE SQL Statements

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

Line: 29

  		SELECT 'x'
  		FROM	IGS_PE_CRS_GRP_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
  			course_group_cd		= p_course_group_cd	AND
  			pcge_start_dt		 <>  p_pcge_start_dt;

Line: 78

  		SELECT	closed_ind
  		FROM	IGS_PS_GRP
  		WHERE	course_group_cd = p_course_group_cd;

Line: 126

  		SELECT	sca.course_cd
  		FROM	IGS_EN_STDNT_PS_ATT	sca,
  			IGS_PS_GRP_MBR	cgm
  		WHERE	sca.person_id		= p_person_id	AND
  			sca.course_attempt_status IN
  				('ENROLLED', 'INACTIVE', 'INTERMIT')	AND
  			sca.course_cd		= cgm.course_cd		AND
  			cgm.course_group_cd	= p_course_group_cd;