APPS.IGS_AD_VAL_ASE SQL Statements

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

Line: 49

  		SELECT	state_cd
  		FROM	IGS_AD_AUSE_ED_AS_TY
  		WHERE	aus_scndry_edu_ass_type = p_aus_scndry_edu_ass_type;

Line: 86

  		SELECT	state_cd
  		FROM	IGS_AD_AUS_SEC_ED_SC
  		WHERE	secondary_school_cd = p_secondary_school_cd;

Line: 121

  		SELECT	closed_ind
  		FROM	IGS_AD_AUSE_ED_AS_TY
  		WHERE	aus_scndry_edu_ass_type = p_aus_scndry_edu_ass_type;