APPS.IGS_EN_VAL_PCE SQL Statements

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

Line: 28

  		SELECT 'x'
  		FROM	IGS_PE_COURSE_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_cd		= p_course_cd		AND
  			expiry_dt	IS NULL				AND
  			pce_start_dt		 <>  p_pce_start_dt;

Line: 68

  p_inserting IN BOOLEAN ,
  p_updating IN BOOLEAN ,
  p_deleting IN BOOLEAN ,
  p_message_name IN OUT NOCOPY VARCHAR2 )
  RETURN BOOLEAN  AS
  	v_index		BINARY_INTEGER;

Line: 80

  			SELECT	*
  			INTO	r_person_course_exclusion
  			FROM	IGS_PE_COURSE_EXCL
  			WHERE	ROWID = gt_rowid_table(v_index);

Line: 181

  		SELECT	census_dt_alias
  		FROM	IGS_GE_S_GEN_CAL_CON
  		WHERE	s_control_num = 1;

Line: 185

  		SELECT	cal_type,
  			ci_sequence_number
  		FROM	IGS_EN_SU_ATTEMPT
  		WHERE	person_id	= p_person_id	AND
  			course_cd	= p_course_cd	AND
  			unit_attempt_status = 'ENROLLED';

Line: 195

  		SELECT	'x'
  		FROM	IGS_CA_DA_INST_V
  		WHERE	cal_type		= cp_cal_type		AND
  			ci_sequence_number 	= cp_ci_sequence_number AND
  			dt_alias 		= cp_dt_alias		AND
  			NVL(alias_val,IGS_GE_DATE.IGSDATE('1900/01/01'))
  				 >= p_exclusion_start_dt;

Line: 286

  		SELECT	'x'
  		FROM	IGS_EN_STDNT_PS_ATT
  		WHERE	person_id = p_person_id		AND
  			course_cd = p_course_cd		AND
  			course_attempt_status IN
  				('ENROLLED', 'INACTIVE', 'INTERMIT');