UFN_BUSINESSPROCESSCOMMPREF_GETDEFAULTEXCLUSIONS

Returns solicitcodes that are marked as default.

Return

Return Type
table

Parameters

Parameter Parameter Type Mode Description
@CURRENTAPPUSERID uniqueidentifier IN

Definition

Copy


            CREATE function dbo.UFN_BUSINESSPROCESSCOMMPREF_GETDEFAULTEXCLUSIONS
            (
                @CURRENTAPPUSERID uniqueidentifier
            )
            returns table
            as
            return
                select SOLICITCODE.ID as SOLICITCODEID
                from dbo.SOLICITCODE
                where SOLICITCODE.EXCLUSIONCODE = 1
                    and SOLICITCODE.ACTIVE = 1
                    and (SOLICITCODE.SITEID in (select SITEID from dbo.UFN_SITESFORUSER(@CURRENTAPPUSERID))
                        or SOLICITCODE.SITEID is null);