APPS.IGS_AD_VAL_AFS SQL Statements

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

Line: 14

  		SELECT	safs.closed_ind
  		FROM	IGS_LOOKUP_VALUES safs
  		WHERE   safs.lookup_type = 'ADM_FEE_STATUS' AND
		        safs.lookup_code = p_s_adm_fee_status;

Line: 56

  		SELECT	count(*),
  			system_default_ind
  		FROM	IGS_AD_FEE_STAT afs
  		WHERE	afs.adm_fee_status <> cp_adm_fee_status AND
  			afs.s_adm_fee_status = cp_s_adm_fee_status AND
  			afs.system_default_ind = cst_yes
  		GROUP BY system_default_ind;