UFN_BILLINGINDIVIDUALPASTDUECHARGES_TOITEMLISTXML

            create function dbo.UFN_BILLINGINDIVIDUALPASTDUECHARGES_TOITEMLISTXML
            (
                @CONSTITUENTID uniqueidentifier,
                @ASOFDATE datetime = null
            )
            returns xml
            with execute as caller
            as begin

                -- If as of date is null use today's date

                if (@ASOFDATE is null)
                    set @ASOFDATE = getdate();

                -- Make sure we are using the earliest time for this date

                set @ASOFDATE = dbo.UFN_DATE_GETEARLIESTTIME(@ASOFDATE);

                declare @PASTDUECHARGES xml;
                set @PASTDUECHARGES = (select ID as CHARGEID,
                                                DUEDATE,
                                                DAYSLATE,
                                                DESCRIPTION,
                                                AMOUNTREMAINING
                                        from dbo.UFN_BILLINGINDIVIDUALTRANSACTIONDETAILS(@CONSTITUENTID,
                                                                                        104,    -- Charges

                                                                                        4,      -- Past due

                                                                                        null,
                                                                                        @ASOFDATE,
                                                                                        null,
                                                                                        null)
                                        for xml raw('ITEM'),type,elements,root('PASTDUECHARGES'),BINARY BASE64);

                return @PASTDUECHARGES;
            end