APPS.IGS_PR_VAL_PRA SQL Statements

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

Line: 136

  		SELECT	'X'
  		FROM	IGS_PR_RU_CAT	prgc
  		WHERE	prgc.progression_rule_cat = p_progression_rule_cat AND
  			prgc.closed_ind = 'N';

Line: 181

  		SELECT	'X'
  		FROM	IGS_PR_RULE	prr
  		WHERE	prr.progression_rule_cd = p_progression_rule_cd AND
  			prr.closed_ind = 'N';

Line: 228

  		SELECT 	'X'
  		FROM	IGS_PS_VER	cst,
  			IGS_PS_STAT	crst
  		WHERE	cst.course_cd		= p_course_cd AND
  			cst.version_number	= p_version_number AND
  			cst.course_status	= crst.course_status AND
  			crst.s_course_status	= cst_active;