APPS.IGS_PR_VAL_PRO SQL Statements

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

Line: 30

  	SELECT	'X'
  	FROM	IGS_PR_OU_TYPE	pot
  	WHERE	pot.progression_outcome_type	= p_progression_outcome_type AND
  		pot.closed_ind			= 'N';

Line: 78

  	SELECT 		'X'
  	FROM		IGS_PR_OU_TYPE 		pot,
  			IGS_FI_ENC_DFLT_EFT		etde
  	WHERE		pot.progression_outcome_type 	= p_progression_outcome_type AND
  		 	pot.encumbrance_type		= etde.encumbrance_type AND
  			etde.s_encmb_effect_type		= cst_rstr_at_ty;

Line: 146

  		SELECT 		etde.s_encmb_effect_type
  		FROM		IGS_PR_OU_TYPE 	pot,
  				IGS_FI_ENC_DFLT_EFT		etde
  		WHERE		pot.progression_outcome_type 	= p_progression_outcome_type AND
  			 	pot.encumbrance_type		= etde.encumbrance_type;

Line: 152

  		SELECT		'X'
  		FROM		IGS_PR_OU_UNIT_SET
  		WHERE		progression_rule_cat 		= p_progression_rule_cat AND
  				pra_sequence_number 		= p_pra_sequence_number AND
  				pro_sequence_number 		= p_sequence_number;

Line: 158

  		SELECT		'X'
  		FROM		IGS_PR_OU_UNIT
  		WHERE		progression_rule_cat 		= p_progression_rule_cat AND
  				pra_sequence_number 		= p_pra_sequence_number AND
  				pro_sequence_number 		= p_sequence_number AND
  				s_unit_type			= cst_excluded;

Line: 165

  		SELECT		'X'
  		FROM		IGS_PR_OU_UNIT
  		WHERE		progression_rule_cat 		= p_progression_rule_cat AND
  				pra_sequence_number 		= p_pra_sequence_number AND
  				pro_sequence_number 		= p_sequence_number AND
  				s_unit_type			= cst_required;

Line: 303

  	SELECT	'X'
  	FROM	IGS_PR_OU_TYPE 		pot,
  		IGS_FI_ENC_DFLT_EFT 		etde
  	WHERE	pot.progression_outcome_type 	= p_progression_outcome_type AND
  		pot.encumbrance_type 		= etde.encumbrance_type AND
  		etde.s_encmb_effect_type 		= cst_exc_crs_gp;

Line: 355

  	SELECT	'X'
  	FROM	IGS_PR_OU_TYPE 		pot,
  		IGS_FI_ENC_DFLT_EFT 		etde
  	WHERE	pot.progression_outcome_type 		= p_progression_outcome_type AND
  		pot.encumbrance_type 			= etde.encumbrance_type AND
  		etde.s_encmb_effect_type 		IN (	cst_rstr_ge_cp,
  							cst_rstr_le_cp);

Line: 431

  		SELECT	'X'
  		FROM	IGS_PR_OU_PS 		poc
  		WHERE	poc.progression_rule_cat 	= p_progression_rule_cat  AND
  			poc.pra_sequence_number		= p_pra_sequence_number	AND
  			poc.pro_sequence_number		= p_sequence_number;

Line: 437

  		SELECT	'X'
  		FROM	IGS_PR_OU_TYPE	pot,
  			IGS_FI_ENC_DFLT_EFT		etde
  		WHERE	pot.progression_outcome_type 	= p_progression_outcome_type  AND
  			pot.encumbrance_type		= etde.encumbrance_type	AND
  			etde.s_encmb_effect_type	IN (
  							cst_exc_course,
  							cst_sus_course);

Line: 446

  		SELECT	'X'
  		FROM	IGS_PR_OU_UNIT_SET		pous
  		WHERE	pous.progression_rule_cat	= p_progression_rule_cat  AND
  			pous.pra_sequence_number	= p_pra_sequence_number	AND
  			pous.pro_sequence_number	= p_sequence_number;

Line: 452

  		SELECT	'X'
  		FROM	IGS_PR_OU_TYPE	pot,
  			IGS_FI_ENC_DFLT_EFT		etde
  		WHERE	pot.progression_outcome_type	= p_progression_outcome_type  AND
  			pot.encumbrance_type		= etde.encumbrance_type	AND
  			etde.s_encmb_effect_type	= cst_exc_crs_us;

Line: 459

  		SELECT	DISTINCT s_unit_type
  		FROM	IGS_PR_OU_UNIT		popu
  		WHERE	popu.progression_rule_cat	= p_progression_rule_cat  AND
  			popu.pra_sequence_number	= p_pra_sequence_number	AND
  			popu.pro_sequence_number	= p_sequence_number;

Line: 465

  		SELECT	'X'
  		FROM	IGS_PR_OU_TYPE	pot,
  			IGS_FI_ENC_DFLT_EFT		etde
  		WHERE	pot.progression_outcome_type	= p_progression_outcome_type  AND
  			pot.encumbrance_type		= etde.encumbrance_type	AND
  			etde.s_encmb_effect_type	= cst_exc_crs_u;

Line: 472

  		SELECT	'X'
  		FROM	IGS_PR_OU_TYPE	pot,
  			IGS_FI_ENC_DFLT_EFT		etde
  		WHERE	pot.progression_outcome_type	= p_progression_outcome_type  AND
  			pot.encumbrance_type		= etde.encumbrance_type	AND
  			etde.s_encmb_effect_type	= cst_rqrd_crs_u;

Line: 480

  		SELECT	'X'
  		FROM	IGS_PR_OU_FND pof
  		WHERE	pof.progression_rule_cat = p_progression_rule_cat  AND
  			pof.pra_sequence_number	 = p_pra_sequence_number   AND
  			pof.pro_sequence_number	 = p_sequence_number;

Line: 487

  		SELECT	'X'
  		FROM	IGS_PR_OU_TYPE	pot,
  			IGS_FI_ENC_DFLT_EFT		etde
  		WHERE	pot.progression_outcome_type	= p_progression_outcome_type  AND
  			pot.encumbrance_type		= etde.encumbrance_type	AND
  			etde.s_encmb_effect_type	= cst_exe_fund;

Line: 646

  	SELECT	pot.s_progression_outcome_type
  	FROM	IGS_PR_OU_TYPE pot
  	WHERE	pot.progression_outcome_type = p_progression_outcome_type;