UFN_PLANNEDGIFTGETSPLITS_XML

            CREATE function dbo.UFN_PLANNEDGIFTGETSPLITS_XML
            (
                @AMOUNT money,
                @PLANNEDGIFTAMOUNT money,
                @SPLITS xml
            )
            returns xml
            as
            BEGIN

                declare @DECIMALDIGITS tinyint = 2;
                select top 1
                    @DECIMALDIGITS = DECIMALDIGITS
                from dbo.CURRENCY
                where CURRENCY.ID = @SPLITS.value('(/DESIGNATION/ITEM/TRANSACTIONCURRENCYID)[1]', 'uniqueidentifier');

                -- Update the xml so that it has the proper root element

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


                return (select AMOUNT, ID as DESIGNATIONID
                        from dbo.UFN_SPLITS_PRORATEAMOUNTS(@AMOUNT, @PLANNEDGIFTAMOUNT, @DECIMALDIGITS, @SPLITS)
                        for xml raw('ITEM'),type,elements,root('DESIGNATION'),binary base64)
            END