UFN_REVENUE_ALLAPPLICATIONS

            CREATE function dbo.UFN_REVENUE_ALLAPPLICATIONS
            (
                @PAYMENTREVENUEID uniqueidentifier 
            )
            returns table
            as
            return
            (
                select --There's no good ID to use for a donation, so just send back an empty guid.

                    '00000000-0000-0000-0000-000000000000' [ID],
                    REVENUESPLIT_EXT.APPLICATIONCODE [TYPECODE]
                from dbo.FINANCIALTRANSACTION
                inner join dbo.FINANCIALTRANSACTIONLINEITEM on FINANCIALTRANSACTIONLINEITEM.FINANCIALTRANSACTIONID = FINANCIALTRANSACTION.ID
                inner join dbo.REVENUESPLIT_EXT on REVENUESPLIT_EXT.ID = FINANCIALTRANSACTIONLINEITEM.ID 
                where FINANCIALTRANSACTION.TYPECODE = 0
                    and FINANCIALTRANSACTION.ID = @PAYMENTREVENUEID 
                    and REVENUESPLIT_EXT.APPLICATIONCODE = 0
                    and REVENUESPLIT_EXT.TYPECODE = 0

                union 
                select 
                    EVENTREGISTRANTPAYMENT.REGISTRANTID [ID],
                    REVENUESPLIT_EXT.APPLICATIONCODE [TYPECODE]
                from dbo.FINANCIALTRANSACTIONLINEITEM 
                inner join dbo.REVENUESPLIT_EXT on REVENUESPLIT_EXT.ID = FINANCIALTRANSACTIONLINEITEM.ID
                inner join dbo.EVENTREGISTRANTPAYMENT on EVENTREGISTRANTPAYMENT.PAYMENTID = REVENUESPLIT_EXT.ID                 
                where FINANCIALTRANSACTIONLINEITEM.FINANCIALTRANSACTIONID = @PAYMENTREVENUEID 


                union
                select 
                    INSTALLMENTPAYMENT.PLEDGEID [ID],
                    REVENUESPLIT_EXT.APPLICATIONCODE [TYPECODE]
                from dbo.FINANCIALTRANSACTIONLINEITEM 
                inner join dbo.REVENUESPLIT_EXT on REVENUESPLIT_EXT.ID = FINANCIALTRANSACTIONLINEITEM.ID
                inner join dbo.INSTALLMENTPAYMENT on INSTALLMENTPAYMENT.PAYMENTID = REVENUESPLIT_EXT.ID
                where FINANCIALTRANSACTIONLINEITEM.FINANCIALTRANSACTIONID = @PAYMENTREVENUEID 

                union
                select
                    RECURRINGGIFTACTIVITY.SOURCEREVENUEID [ID],
                    REVENUESPLIT_EXT.APPLICATIONCODE [TYPECODE]
                from dbo.FINANCIALTRANSACTIONLINEITEM 
                inner join dbo.REVENUESPLIT_EXT on REVENUESPLIT_EXT.ID = FINANCIALTRANSACTIONLINEITEM.ID
                inner join dbo.RECURRINGGIFTACTIVITY on RECURRINGGIFTACTIVITY.PAYMENTREVENUEID = REVENUESPLIT_EXT.ID
                where FINANCIALTRANSACTIONLINEITEM.FINANCIALTRANSACTIONID = @PAYMENTREVENUEID

                union
                select
                    REVENUESPLIT_EXT.ID,
                    REVENUESPLIT_EXT.APPLICATIONCODE [TYPECODE]
                from dbo.FINANCIALTRANSACTIONLINEITEM 
                inner join dbo.REVENUESPLIT_EXT on REVENUESPLIT_EXT.ID = FINANCIALTRANSACTIONLINEITEM.ID
                inner join dbo.REVENUESPLITOTHER on REVENUESPLITOTHER.ID = REVENUESPLIT_EXT.ID
                where FINANCIALTRANSACTIONLINEITEM.FINANCIALTRANSACTIONID = @PAYMENTREVENUEID

                union
                select 
                    MEMBERSHIPTRANSACTION.ID,
                    REVENUESPLIT_EXT.APPLICATIONCODE [TYPECODE]
                from dbo.FINANCIALTRANSACTIONLINEITEM 
                inner join dbo.REVENUESPLIT_EXT on REVENUESPLIT_EXT.ID = FINANCIALTRANSACTIONLINEITEM.ID
                inner join dbo.MEMBERSHIPTRANSACTION on MEMBERSHIPTRANSACTION.REVENUESPLITID = REVENUESPLIT_EXT.ID
                where FINANCIALTRANSACTIONLINEITEM.FINANCIALTRANSACTIONID = @PAYMENTREVENUEID

                union 
                select 
                    AUCTIONITEMPURCHASE.AUCTIONITEMID [ID],
                    REVENUESPLIT_EXT.APPLICATIONCODE [TYPECODE]
                from dbo.FINANCIALTRANSACTIONLINEITEM 
                inner join dbo.REVENUESPLIT_EXT on REVENUESPLIT_EXT.ID = FINANCIALTRANSACTIONLINEITEM.ID
                inner join dbo.AUCTIONITEMPURCHASE on AUCTIONITEMPURCHASE.PURCHASEID = REVENUESPLIT_EXT.ID
                where FINANCIALTRANSACTIONLINEITEM.FINANCIALTRANSACTIONID = @PAYMENTREVENUEID
            )