UFN_RECOGNITIONCREDIT_GETRECOGNITIONS_NOCONSTITNAME

create function dbo.UFN_RECOGNITIONCREDIT_GETRECOGNITIONS_NOCONSTITNAME
(
  @CURRENCYID uniqueidentifier,
  @DECIMALDIGITS tinyint,
  @ROUNDINGTYPECODE tinyint,
  @ORGANIZATIONCURRENCYID uniqueidentifier
)
returns table
as return (               
    select
        RR.ID,
        RR.REVENUESPLITID,
        RR.EFFECTIVEDATE,
        RR.AMOUNT,
        RR.ORGANIZATIONAMOUNT,
        RR.CONSTITUENTID,
        RR.DATEADDED,
        RR_INCURRENCY.AMOUNTINCURRENCY,
        RR_INCURRENCY.TRANSACTIONTYPE,
        RR_INCURRENCY.TRANSACTIONTYPECODE,
        RR_INCURRENCY.REVENUEID,
        RR_INCURRENCY.APPLICATIONCODE,  
        RR_INCURRENCY.REVENUESPLITTYPECODE      
    from dbo.UFN_REVENUERECOGNITION_GETAMOUNTINCURRENCY_BULK(@CURRENCYID,@ORGANIZATIONCURRENCYID,@DECIMALDIGITS,@ROUNDINGTYPECODE) as RR_INCURRENCY
    inner join dbo.REVENUERECOGNITION as RR on RR.ID = RR_INCURRENCY.ID

    union all

    select
        RECOGNITIONCREDIT.ID,
        DONORCHALLENGEENCUMBERED.REVENUESPLITID as REVENUESPLITID, --This should be null but we still store some info on the revenue, REVENUECAMPAIGN for example

        RECOGNITIONCREDIT.EFFECTIVEDATE,
        RECOGNITIONCREDIT.AMOUNT,
        RECOGNITIONCREDIT.ORGANIZATIONAMOUNT,
        RECOGNITIONCREDIT.CONSTITUENTID,
        RECOGNITIONCREDIT.DATEADDED,
        RECOGNITIONCREDIT_INCURRENCY.AMOUNTINCURRENCY,
        'Donor challenge claim - Internal sponsor' as TYPE,
        8 as TYPECODE,
        RECOGNITIONCREDIT_INCURRENCY.REVENUEID,
        RECOGNITIONCREDIT_INCURRENCY.APPLICATIONCODE,  
        RECOGNITIONCREDIT_INCURRENCY.REVENUESPLITTYPECODE  
    from dbo.UFN_RECOGNITIONCREDIT_GETAMOUNTINCURRENCY_BULK(@CURRENCYID,@ORGANIZATIONCURRENCYID,@DECIMALDIGITS,@ROUNDINGTYPECODE) as RECOGNITIONCREDIT_INCURRENCY
    inner join dbo.RECOGNITIONCREDIT on RECOGNITIONCREDIT.ID = RECOGNITIONCREDIT_INCURRENCY.ID
    inner join dbo.DONORCHALLENGEENCUMBERED on RECOGNITIONCREDIT.DONORCHALLENGEENCUMBEREDID = DONORCHALLENGEENCUMBERED.ID
    where RECOGNITIONCREDIT.RECOGNITIONCREDITTYPECODE = 1
)