spGetEmailTemplatesForBOSystem

      CREATE procedure [dbo].[spGetEmailTemplatesForBOSystem]
      (
            @clientsID int,
            @BackOfficeSystemID int,
            @IncludedDeleted bit 
      )

      as 
      select      [et].[id], [et].DataSourceID,
            [et].[name], [et].[Description], 
                  [et].[Subject]  
      from emailtemplate et
      INNER JOIN DataSources ds on et.DataSourceID = ds.DataSourceID AND ds.Deleted = 0
      where ds.BackOfficeSystemID = @BackOfficeSystemID
      and et.clientsid=@clientsID
      and et.deleted in (0, @IncludedDeleted)
      order by [et].[name]