APPS.IGS_AD_VAL_TE SQL Statements

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

Line: 16

  		SELECT	local_institution_ind
  		FROM	IGS_OR_INSTITUTION
  		WHERE	institution_cd = p_institution_cd;

Line: 92

  		SELECT 	'X'
  		FROM	IGS_AD_TER_ED_LV_COM teloc
  		WHERE	teloc.tertiary_edu_lvl_comp	= p_tertiary_edu_lvl_comp AND
  			teloc.closed_ind = 'Y';

Line: 129

  		SELECT 	'X'
  		FROM	IGS_AD_TER_ED_LVL_QF teloq
  		WHERE	teloq.tertiary_edu_lvl_qual = p_tertiary_edu_lvl_qual AND
  			teloq.closed_ind = 'Y';