UFN_BBMS_GET_TRANSACTION_CURRENCY

create function dbo.UFN_BBMS_GET_TRANSACTION_CURRENCY
(
    @TRANSACTIONID uniqueidentifier
    ,@CURRENCY nvarchar(1000)
)
returns uniqueidentifier
with execute as caller
as begin
    declare @CURRENCYID uniqueidentifier;

    if @TRANSACTIONID is not null
        select @CURRENCYID = FT.TRANSACTIONCURRENCYID
        from dbo.CREDITCARDPAYMENTMETHODDETAIL CCD
        inner join dbo.REVENUEPAYMENTMETHOD RPM on CCD.ID = RPM.ID
        inner join dbo.FINANCIALTRANSACTION FT on FT.ID = RPM.REVENUEID
        where CCD.TRANSACTIONID = @TRANSACTIONID;

    if @CURRENCYID is null and nullif(@CURRENCY, '') is not null
        select @CURRENCYID = C.ID
        from dbo.CURRENCY C
        where C.ISO4217 = @CURRENCY;

    return @CURRENCYID;
end