USP_DATALIST_DISBURSEMENTPROCESSTEMPLATE

CREATE procedure dbo.USP_DATALIST_DISBURSEMENTPROCESSTEMPLATE
as
    set nocount on;

    select D.ID,
         D.TYPE,
         NAME,
         D.DESCRIPTION,
         B.ACCOUNTNAME,
         dbo.UFN_DISBURSEMENTPROCESSTEMPLATE_GETDATESTRING(D.DISBURSEMENTDATENUMBEROFDAYS, null) as DISBURSEMENTDATE,
         --'' as FORMATS --

         dbo.UFN_DISBURSEMENTPROCESSTEMPLATE_FORMATS(D.ID) as FORMATS
    from dbo.DISBURSEMENTPROCESSTEMPLATE D
  inner join dbo.BANKACCOUNT B on B.ID = D.BANKACCOUNTID