UFN_REVENUEBATCH_GETSPLITS

            CREATE function dbo.UFN_REVENUEBATCH_GETSPLITS(@BATCHREVENUEID uniqueidentifier)
            returns table
            as
            return
            (
                select
                    ID, 
                    DESIGNATIONID, 
                    AMOUNT, 
                    SEQUENCE, 
                    APPLICATIONCODE, 
                    TYPECODE,
                    1 as DIDCAMPAIGNSDEFAULT,
                    (select
                        ID,
                        CAMPAIGNID,
                        CAMPAIGNSUBPRIORITYID,
                        REVENUESPLITCAMPAIGNID
                    from dbo.BATCHREVENUESPLITCAMPAIGN
                    where BATCHREVENUESPLITCAMPAIGN.BATCHREVENUESPLITID = BATCHREVENUESPLIT.ID
                    for xml raw('ITEM'),type,elements,BINARY BASE64) as CAMPAIGNS,
                    DECLINESGIFTAID, ISGIFTAIDSPONSORSHIP, REVENUESPLITID
                from dbo.BATCHREVENUESPLIT where BATCHREVENUEID = @BATCHREVENUEID
            )