USP_SIMPLEDATALIST_MKTLETTERCODEEXPORTDEFINITION

CREATE procedure dbo.[USP_SIMPLEDATALIST_MKTLETTERCODEEXPORTDEFINITION]
(
  @MAILINGTYPECODE tinyint = null
)
as
  set nocount on;

  select 
    [EXPORTDEFINITION].[ID] as [VALUE],
    [EXPORTDEFINITION].[NAME] as [LABEL]
  from dbo.[EXPORTDEFINITION]
  where (@MAILINGTYPECODE is null or @MAILINGTYPECODE = 255 or dbo.[UFN_MKTEXPORTDEFINITION_GETMAILINGTYPECODEFROMRECORDTYPEID]([EXPORTDEFINITION].[RECORDTYPEID]) = @MAILINGTYPECODE)
    --and [EXPORTDEFINITION].[ISSYSTEM] = 0

  order by [EXPORTDEFINITION].[NAME];

  return 0;