UFN_MKTCOMMUNICATIONTEMPLATEDEFAULTBUSINESSUNIT_GETBUSINESSUNITS

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@COMMUNICATIONTEMPLATEID	uniqueidentifier	IN

Definition

Copy



create function dbo.[UFN_MKTCOMMUNICATIONTEMPLATEDEFAULTBUSINESSUNIT_GETBUSINESSUNITS]
(
  @COMMUNICATIONTEMPLATEID uniqueidentifier
)
returns table
as return
      select
        [ID],
        [BUSINESSUNITCODEID],
        [PERCENTVALUE]
      from
        dbo.[MKTCOMMUNICATIONTEMPLATEDEFAULTBUSINESSUNIT]
      where
        [COMMUNICATIONTEMPLATEID] = @COMMUNICATIONTEMPLATEID;