UFN_POST_DEPOSITTEMPLATES_TOITEMLISTXML

CREATE function dbo.UFN_POST_DEPOSITTEMPLATES_TOITEMLISTXML
(
    @POSTTOGLPROCESSID uniqueidentifier = null
)
returns xml
as begin
    declare @XML xml
    set @XML = (
        select
            F.ID
            ,case when @POSTTOGLPROCESSID is null then 1 else case when F.ID is null then 0 else 1 end end as [INCLUDE]
            ,DT.ID as [SALESDEPOSITTEMPLATEID]
            ,DT.NAME as [NAME]
            ,BA.ACCOUNTNAME
            ,(select dbo.UDA_BUILDLIST(SDTPM.PAYMENTMETHOD) 
                from (select distinct PAYMENTMETHOD, SALESDEPOSITTEMPLATEID from dbo.SALESDEPOSITTEMPLATEPAYMENTMETHOD) as SDTPM
                where SDTPM.SALESDEPOSITTEMPLATEID = DT.ID) as [PAYMENTMETHOD]
            ,BA.PDACCOUNTSYSTEMID
        from dbo.SALESDEPOSITTEMPLATE DT
        inner join dbo.BANKACCOUNT BA on DT.BANKACCOUNTID = BA.ID
        left join dbo.POSTTOGLPROCESSDEPOSITTEMPLATESFILTER F on @POSTTOGLPROCESSID is not null and F.SALESDEPOSITTEMPLATEID = DT.ID and F.POSTTOGLPROCESSID = @POSTTOGLPROCESSID
        where BA.STATUSCODE = 1
        order by DT.NAME
        for xml raw('ITEM'), type, elements, root('DEPOSITTEMPLATES'), BINARY BASE64
    )
    set @XML = isnull(@XML, '<DEPOSITTEMPLATES></DEPOSITTEMPLATES>')
    return @XML

end