USP_DATALIST_EVENTPROFILEREPORT_APPEAL

CREATE procedure dbo.USP_DATALIST_EVENTPROFILEREPORT_APPEAL
(
    @EVENTID uniqueidentifier,
    @ISVISIBLE bit = 1,
  @CURRENCYCODE tinyint = null
)
as
    set nocount on;

    declare @SELECTEDCURRENCYID uniqueidentifier;
  declare @DECIMALDIGITS tinyint;
  declare @ROUNDINGTYPECODE tinyint;          

  if @CURRENCYCODE = 0
    select @SELECTEDCURRENCYID = EVENT.BASECURRENCYID
    from dbo.EVENT
    where EVENT.ID = @EVENTID
    else
        set @SELECTEDCURRENCYID = dbo.UFN_CURRENCY_GETORGANIZATIONCURRENCY();

    select
        @DECIMALDIGITS = CURRENCY.DECIMALDIGITS,
        @ROUNDINGTYPECODE = CURRENCY.ROUNDINGTYPECODE
    from
        dbo.CURRENCY
    where
        CURRENCY.ID = @SELECTEDCURRENCYID;

    if @ISVISIBLE = 1
    begin
        select
            APPEAL.ID as APPEALID,
            APPEAL.NAME,
      'http://www.blackbaud.com/APPEALID?APPEALID='+convert(nvarchar(36),APPEAL.ID) APPEALLINK,
            G.GOALINCURRENCY 'GOAL',
      dbo.UFN_APPEAL_GETTOTALREVENUEINCURRENCY(APPEAL.ID, @SELECTEDCURRENCYID) 'INCOME',
        CURRENCYPROPERTIES.ISO4217 [ISOCURRENCYCODE],
        CURRENCYPROPERTIES.CURRENCYSYMBOL,
      CURRENCYPROPERTIES.SYMBOLDISPLAYSETTINGCODE [CURRENCYSYMBOLDISPLAYSETTINGCODE],
        CURRENCYPROPERTIES.DECIMALDIGITS
        from
            dbo.EVENTAPPEAL
            inner join dbo.APPEAL on APPEAL.ID = EVENTAPPEAL.APPEALID
      left join dbo.UFN_APPEAL_GETGOALINCURRENCY_BULK(@SELECTEDCURRENCYID,dbo.UFN_CURRENCY_GETORGANIZATIONCURRENCY(),@DECIMALDIGITS,@ROUNDINGTYPECODE) as G on G.ID = APPEAL.ID
      outer apply dbo.UFN_CURRENCY_GETPROPERTIES(@SELECTEDCURRENCYID) CURRENCYPROPERTIES
        where
            EVENTAPPEAL.EVENTID = @EVENTID
        order by
            APPEAL.NAME
    end