USP_KPI_MARKETING_MAILING_AVERAGEGIFTAMOUNT_GOAL

CREATE procedure dbo.[USP_KPI_MARKETING_MAILING_AVERAGEGIFTAMOUNT_GOAL]
(
  @VALUE money output,
  @SEGMENTATIONID uniqueidentifier = null,
  @SELECTIONID uniqueidentifier = null,
  @CURRENCYCODE tinyint = 2,
  @CURRENCYID uniqueidentifier = null
)
as
  set nocount on;

  declare @r int;

  if @CURRENCYID is null 
    if @SEGMENTATIONID is not null
      select @CURRENCYID = [BASECURRENCYID] from dbo.[MKTSEGMENTATION] where [ID] = @SEGMENTATIONID
    else
      set @CURRENCYID = dbo.[UFN_CURRENCY_GETORGANIZATIONCURRENCY]();
  else if @SELECTIONID is not null
    set @CURRENCYID = dbo.[UFN_CURRENCY_GETORGANIZATIONCURRENCY]();

  exec @r = dbo.[USP_KPI_MARKETING_MAILING_AVERAGEGIFTAMOUNT_GOAL_INTERNAL_WITHIDSET] @SELECTIONID, @SEGMENTATIONID, @VALUE output, @CURRENCYID;

  return @r;