APPS.IGS_AD_VAL_AAS SQL Statements

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

Line: 15

  		SELECT	slv.closed_ind
  		FROM	IGS_LOOKUP_VALUES slv
  		WHERE   slv.lookup_type = 'ADM_APPL_STATUS' AND
		        slv.Lookup_code = p_s_adm_appl_status;

Line: 59

  		SELECT	count(*),
  			system_default_ind
  		FROM	IGS_AD_APPL_STAT aas
  		WHERE	aas.adm_appl_status <> cp_adm_appl_status AND
  			aas.s_adm_appl_status = cp_s_adm_appl_status AND
  			aas.system_default_ind = cst_yes
  		GROUP BY system_default_ind;