USP_SIMPLEDATALIST_BATCHPROCESSOR

CREATE procedure dbo.USP_SIMPLEDATALIST_BATCHPROCESSOR(@BATCHTEMPLATEID uniqueidentifier = null)
as begin

    declare @SITEID uniqueidentifier;
    select @SITEID = SITEID from dbo.BATCHTEMPLATE where ID = @BATCHTEMPLATEID;

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

    order by LABEL
end