USP_BUSINESSPROCESSOUTPUTLETTERTEMPLATE_DATALIST

Displays a list of letter templates associated with a business process output.

Parameters

Parameter	Parameter Type	Mode	Description
@BUSINESSPROCESSOUTPUTTABLEKEY	nvarchar(50)	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



create procedure dbo.[USP_BUSINESSPROCESSOUTPUTLETTERTEMPLATE_DATALIST] 
(
    @BUSINESSPROCESSOUTPUTTABLEKEY nvarchar(50)
)
with execute as owner
as
  set nocount on;

    select
        [ID],
    [WORDTEMPLATEID],
        [LETTERTEMPLATENAME] 
    from dbo.[BUSINESSPROCESSOUTPUTTEMPLATE] 
    where [BUSINESSPROCESSOUTPUTTABLEKEY] = @BUSINESSPROCESSOUTPUTTABLEKEY
  and [LETTERTEMPLATE] is not null;