APPS.IGS_AD_VAL_AC SQL Statements

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

Line: 14

  		SELECT		apc.admission_cat
  		FROM		IGS_AD_PRCS_CAT apc
  		WHERE	apc.admission_cat = p_admission_cat
		AND     closed_ind = 'N';                    --added the closed indicator for bug# 2380108 (rghosh)

Line: 19

  	-- Validate if the admission_cat can be updated
  	p_message_name := null;

Line: 24

		p_message_name := 'IGS_AD_ADMCAT_CANNOT_UPDATED';