APPS.IGS_AD_VAL_AORS SQL Statements

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

Line: 14

  		SELECT	saors.closed_ind
  		FROM	IGS_LOOKUP_VALUES saors
  		WHERE   saors.lookup_type = 'ADM_OFFER_RESP_STATUS' AND
		        saors.lookup_code = p_s_adm_offer_resp_status;

Line: 55

  		SELECT	count(*),
  			system_default_ind
  		FROM	IGS_AD_OFR_RESP_STAT aors
  		WHERE	aors.adm_offer_resp_status <> p_adm_offer_resp_status AND
  			aors.s_adm_offer_resp_status = p_s_adm_offer_resp_status AND
  			aors.system_default_ind = 'Y'
  		GROUP BY system_default_ind;