USP_SIMPLEDATALIST_BATCHWORKFLOWTASKAVAILABLEUSERS

CREATE procedure dbo.USP_SIMPLEDATALIST_BATCHWORKFLOWTASKAVAILABLEUSERS
(
    @BATCHWORKFLOWTASKID uniqueidentifier = null,
    @BATCHID uniqueidentifier = null
)
as begin

    declare @SITEID uniqueidentifier;
    select @SITEID = SITEID from dbo.BATCHTEMPLATE inner join dbo.BATCH on BATCHTEMPLATE.ID = BATCH.BATCHTEMPLATEID where BATCH.ID = @BATCHID;

    select ID as VALUE, case when DISPLAYNAME = '' then USERNAME else DISPLAYNAME end as LABEL 
    from dbo.APPUSER
    where dbo.UFN_SECURITY_APPUSER_GRANTED_BATCHWORKFLOWTASK(APPUSER.ID, @BATCHWORKFLOWTASKID) = 1
    and (@BATCHID is null or @SITEID is null or dbo.UFN_SITEALLOWEDFORUSER(APPUSER.ID, @SITEID) = 1)

    order by LABEL
end