UFN_RECURRINGGIFT_ISMEMBERSHIP

            create function dbo.UFN_RECURRINGGIFT_ISMEMBERSHIP
            (
                @RECURRINGGIFTID uniqueidentifier
            )
            returns bit
            with execute as caller
            as
            begin
                declare @r as integer = 0;

                select @r = 1
                from dbo.FINANCIALTRANSACTION
                inner join dbo.FINANCIALTRANSACTIONLINEITEM on FINANCIALTRANSACTION.ID = FINANCIALTRANSACTIONLINEITEM.FINANCIALTRANSACTIONID
                inner join dbo.REVENUESPLIT_EXT on FINANCIALTRANSACTIONLINEITEM.ID = REVENUESPLIT_EXT.ID
                where FINANCIALTRANSACTION.ID = @RECURRINGGIFTID
                    and FINANCIALTRANSACTION.TYPECODE = 2
                    and REVENUESPLIT_EXT.TYPECODE = 2
                    and REVENUESPLIT_EXT.APPLICATIONCODE = 5

                return @r
            end