UFN_COMMUNICATIONLETTER_GETINCLUDEDSELECTIONS

Retrieve the selections to be included in an appeal mailing letter.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@COMMUNICATIONLETTERID	uniqueidentifier	IN

Definition

Copy



create function dbo.UFN_COMMUNICATIONLETTER_GETINCLUDEDSELECTIONS
(
    @COMMUNICATIONLETTERID uniqueidentifier
)
returns table as
    return (
        select
            COMMUNICATIONLETTERSELECTION.ID,
            COMMUNICATIONLETTERSELECTION.IDSETREGISTERID as SELECTIONID,
            IDSETREGISTER.NAME
        from dbo.COMMUNICATIONLETTERSELECTION  
        inner join dbo.IDSETREGISTER
            on COMMUNICATIONLETTERSELECTION.IDSETREGISTERID = IDSETREGISTER.ID
        where COMMUNICATIONLETTERID = @COMMUNICATIONLETTERID
            and FILTERTYPECODE = 0
)