DBA Data[Home] [Help]

APPS.IGS_AD_VAL_AOS SQL Statements

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

Line: 20

  		SELECT	count(*),
  			system_default_ind
  		FROM	IGS_AD_OU_STAT aos
  		WHERE	aos.adm_outcome_status <> p_adm_outcome_status AND
  			aos.s_adm_outcome_status = p_s_adm_outcome_status AND
  			aos.system_default_ind = 'Y'
  		GROUP BY system_default_ind;