USP_KPI_MARKETING_MEMBERSHIPMAILING_COSTPERRENEWAL_GOAL

Parameters

Parameter	Parameter Type	Mode
@VALUE	money	INOUT
@SEGMENTATIONID	uniqueidentifier	IN
@SELECTIONID	uniqueidentifier	IN
@CURRENCYCODE	tinyint	IN
@CURRENCYID	uniqueidentifier	IN

Definition

Copy



CREATE procedure dbo.[USP_KPI_MARKETING_MEMBERSHIPMAILING_COSTPERRENEWAL_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_MEMBERSHIPMAILING_COSTPERRENEWAL_GOAL_INTERNAL_WITHIDSET] @SELECTIONID, @SEGMENTATIONID, @VALUE output, @CURRENCYID;

  return @r;