APPS.IGS_PR_VAL_POC SQL Statements

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

Line: 16

  		SELECT	'x'
  		FROM	IGS_PS_VER	crv,
  			IGS_PS_STAT  	cst
  		WHERE	crv.course_cd		= p_course_cd AND
  			crv.course_status	= cst.course_status AND
  			cst.s_course_status	= 'ACTIVE';

Line: 69

  		SELECT 	'X'
  		FROM		IGS_PR_RU_OU	pro,
  				IGS_PR_OU_TYPE 	pot,
  				IGS_FI_ENC_DFLT_EFT		etde
  		WHERE		pro.progression_rule_cat	= p_progression_rule_cat AND
  				pro.pra_sequence_number		= p_pra_sequence_number AND
  				pro.sequence_number		= p_sequence_number AND
  				pro.progression_outcome_type 	= pot.progression_outcome_type AND
  				pot. encumbrance_type		= etde.encumbrance_type  AND
  				etde.s_encmb_effect_type	IN (
  								cst_exc_course,
  								cst_sus_course);