APPS.IGS_AD_VAL_AUOS SQL Statements

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

Line: 14

  		SELECT	saos.closed_ind
  		FROM	IGS_LOOKUP_values saos
  		WHERE   saos.lookup_code = p_s_adm_outcome_status
		AND     saos.lookup_type = 'ADM_OUTCOME_STATUS';

Line: 53

  		SELECT 	'X'
  		FROM	IGS_LOOKUPS_VIEW	saos
  		WHERE	saos.lookup_type   = 'ADM_OUTCOME_STATUS' AND
		        saos.lookup_code	= p_s_adm_outcome_status	AND
  			saos.unit_outcome_ind		<> 'Y';

Line: 99

  		SELECT 	'X'
  		FROM	IGS_AD_UNIT_OU_STAT	auos
  		WHERE	auos.adm_unit_outcome_status	<> p_adm_unit_outcome_status	AND
  			auos.s_adm_outcome_status	= p_s_adm_outcome_status	AND
  			auos.system_default_ind		= 'Y';