USP_MKTMEMBERSHIPMAILINGPROCESS_GETTEMPLATERULES

CREATE procedure dbo.[USP_MKTMEMBERSHIPMAILINGPROCESS_GETTEMPLATERULES]
(
  @TEMPLATEID uniqueidentifier
)
as
  set nocount on;

  select
    [MKTMEMBERSHIPMAILINGTEMPLATERULE].[ID] as [TEMPLATERULEID],
    [MKTSEGMENT].[ID] as [SEGMENTID],
    [MKTSEGMENT].[NAME] as [SEGMENTNAME],
    dbo.[UFN_MKTSELECTION_GETFUNCTIONNAME]([MKTSEGMENT].[IDSETREGISTERID]) as [IDSETTABLENAME],
    [MKTPACKAGE].[CHANNELCODE]
  from dbo.[MKTMEMBERSHIPMAILINGTEMPLATERULE]
  inner join dbo.[MKTSEGMENT] on [MKTSEGMENT].[ID] = [MKTMEMBERSHIPMAILINGTEMPLATERULE].[SEGMENTID]
  left outer join dbo.[MKTPACKAGE] on [MKTPACKAGE].[ID] = [MKTMEMBERSHIPMAILINGTEMPLATERULE].[PACKAGEID]
  where [MKTMEMBERSHIPMAILINGTEMPLATERULE].[MEMBERSHIPMAILINGTEMPLATEID] = @TEMPLATEID
  order by [MKTMEMBERSHIPMAILINGTEMPLATERULE].[SEQUENCE];

  return 0;