UFN_BUSINESSPROCESSCOMMPREF_GETEXCLUSIONS

Returns business process communication preferences exclusion solicit codes.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@BUSINESSPROCESSPARAMETERSETID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_BUSINESSPROCESSCOMMPREF_GETEXCLUSIONS
            (
                @BUSINESSPROCESSPARAMETERSETID uniqueidentifier
            )
            returns table
            as
                return(
                    select
                        BUSINESSPROCESSCOMMPREFEXCLUSIONS.ID,
                        BUSINESSPROCESSCOMMPREFEXCLUSIONS.SOLICITCODEID
                    from 
                        dbo.BUSINESSPROCESSCOMMPREFEXCLUSIONS
                    where 
                        BUSINESSPROCESSPARAMETERSETID = @BUSINESSPROCESSPARAMETERSETID)