APPS.IGS_AD_VAL_AODS SQL Statements

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

Line: 14

  		SELECT	saods.closed_ind
  		FROM	IGS_LOOKUP_VALUES saods
  		WHERE   saods.lookup_type = 'ADM_OFFER_DFRMNT_STATUS' AND
		        saods.lookup_code = p_s_adm_offer_dfrmnt_status ;

Line: 59

  		SELECT	count(*),
  			system_default_ind
  		FROM	IGS_AD_OFRDFRMT_STAT aods
  		WHERE	aods.adm_offer_dfrmnt_status <> cp_adm_offer_dfrmnt_status AND
  			aods.s_adm_offer_dfrmnt_status = cp_s_adm_offer_dfrmnt_status AND
  			aods.system_default_ind = cst_yes
  		GROUP BY system_default_ind;