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);