UFN_REVENUEBATCH_EVENTREGISTRANT_GETBALANCE

            CREATE function dbo.UFN_REVENUEBATCH_EVENTREGISTRANT_GETBALANCE
            (
                @REGISTRANTID uniqueidentifier
            )
            returns money
            as
            begin

                -- Not including @PAIDAMOUNT since no payments can have occurred inside of batch yet.


                declare @REGISTRANTAMOUNT money;
                -- declare @PAIDAMOUNT money;


                -- set @PAIDAMOUNT = 0;

                set @REGISTRANTAMOUNT= 0;

                select
                    @REGISTRANTAMOUNT= sum(AMOUNT)
                from 
                    dbo.BATCHREVENUEREGISTRANTREGISTRATION 
                where 
                    REGISTRANTID = @REGISTRANTID;

                /*
                select
                    @PAIDAMOUNT = sum(REVENUESPLIT.AMOUNT) 
                from dbo.REVENUESPLIT
                inner join dbo.EVENTREGISTRANTPAYMENT as [PAYMENT] on [PAYMENT].PAYMENTID = REVENUESPLIT.ID
                where [PAYMENT].REGISTRANTID = @REGISTRANTID; 

                return coalesce(@REGISTRANTAMOUNT, 0) - coalesce(@PAIDAMOUNT, 0);
                */

                return coalesce(@REGISTRANTAMOUNT, 0);

            end