APPS.IGS_PR_VAL_POT SQL Statements

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

Line: 30

  		SELECT	'X'
  		FROM	IGS_FI_ENC_DFLT_EFT 	etde
  		WHERE	etde.encumbrance_type	= p_encumbrance_type AND
  			etde.s_encmb_effect_type	= cst_rstr_at_ty;

Line: 85

  		SELECT	'X'
  		FROM	IGS_FI_ENC_DFLT_EFT 	etde
  		WHERE	etde.encumbrance_type	= p_encumbrance_type AND
  			etde.s_encmb_effect_type IN (
  						cst_rstr_ge_cp,
  						cst_rstr_le_cp);

Line: 179

  		SELECT 	et.s_encumbrance_cat
  		FROM	IGS_FI_ENCMB_TYPE 		et
  		WHERE	et.encumbrance_type		= p_encumbrance_type;

Line: 183

  		SELECT	edte.s_encmb_effect_type
  		FROM	IGS_FI_ENC_DFLT_EFT 		edte
  		WHERE	edte.encumbrance_type		= p_encumbrance_type;

Line: 357

  		SELECT	'X'
  		FROM	IGS_PR_RU_OU 	pro
  		WHERE	pro.progression_outcome_type	= p_progression_outcome_type;

Line: 361

  		SELECT	'X'
  		FROM	IGS_PR_STDNT_PR_OU 	spo
  		WHERE	spo.progression_outcome_type	= p_progression_outcome_type;

Line: 423

  		SELECT	'X'
  		FROM	IGS_PR_RU_OU 	pro
  		WHERE	pro.progression_outcome_type	= p_progression_outcome_type;

Line: 427

  		SELECT	'X'
  		FROM	IGS_PR_STDNT_PR_OU 	spo
  		WHERE	spo.progression_outcome_type	= p_progression_outcome_type;

Line: 485

  		SELECT	spot.closed_ind
  		FROM	IGS_LOOKUPS_VIEW	spot
  		WHERE	spot.LOOKUP_TYPE	= p_s_prog_outcome_type;