APPS.IGS_AD_VAL_ACOS SQL Statements

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

Line: 14

  		SELECT	sacos.closed_ind
  		FROM	IGS_LOOKUP_VALUES sacos
  		WHERE   sacos.lookup_type = 'ADM_CNDTNL_OFFER_STATUS' AND
		        sacos.lookup_code = p_s_adm_cndtnl_offer_status;

Line: 54

  		SELECT	count(*),
  			system_default_ind
  		FROM	IGS_AD_CNDNL_OFRSTAT acos
  		WHERE	acos.adm_cndtnl_offer_status <> p_adm_cndtnl_offer_status AND
  			acos.s_adm_cndtnl_offer_status = p_s_adm_cndtnl_offer_status AND
  			acos.system_default_ind = 'Y'
  		GROUP BY system_default_ind;