UFN_APPUSER_GETBASECURRENCY

            create function dbo.UFN_APPUSER_GETBASECURRENCY
            (
                @APPUSERID uniqueidentifier
            ) 
            returns uniqueidentifier
            with execute as caller
            as
            begin
                declare @CURRENCYID uniqueidentifier;

                select 
                    @CURRENCYID = CURRENCYSET.BASECURRENCYID
                from 
                    dbo.CURRENCYSET
                    inner join dbo.APPUSERCURRENCYSET on APPUSERCURRENCYSET.CURRENCYSETID = CURRENCYSET.ID
                where
                    APPUSERCURRENCYSET.APPUSERID = @APPUSERID;

                if @CURRENCYID is null
                begin
                    select 
                        @CURRENCYID = BASECURRENCYID
                    from 
                        dbo.CURRENCYSET
                    where
                        ISAPPUSERDEFAULT = 1;

                    if @CURRENCYID is null
                    begin
                        select @CURRENCYID = dbo.UFN_CURRENCY_GETORGANIZATIONCURRENCY();
                    end
                end

                return @CURRENCYID;
            end