USP_MKTSPONSORSHIPMAILINGPROCESS_GETTEMPLATERULES

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

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

  return 0;