UFN_MATCHINGGIFT_GETAUTOADDSPLITS

            CREATE FUNCTION dbo.UFN_MATCHINGGIFT_GETAUTOADDSPLITS
            (
                @AMOUNT money,
                @MATCHINGGIFTAMOUNT money,
                @SPLITS xml
            )
            returns xml
            as
            BEGIN
                -- Update the xml so that it has the proper root element

                set @SPLITS = (
                    select AMOUNT, DESIGNATIONID as ID 
                        from dbo.UFN_REVENUE_GETSPLITS_FROMITEMLISTXML(@SPLITS)
                        where TYPECODE = 0
                        for xml raw('ITEM'),type,elements,root('AMOUNTSTOPRORATE'),binary base64
                )

                return (select AMOUNT, ID as DESIGNATIONID, 0 as TYPECODE, 0 as APPLICATIONCODE
                        from dbo.UFN_SPLITS_GETPRORATEDSPLITS(@AMOUNT, @MATCHINGGIFTAMOUNT, @SPLITS)
                        for xml raw('ITEM'),type,elements,root('SPLITS'),binary base64)
            END