USP_SIMPLEDATALIST_BATCHAPPROVER
Returns the set of application users available as batch approvers
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @BATCHTEMPLATEID | uniqueidentifier | IN | Batch template id |
Definition
Copy
create procedure dbo.USP_SIMPLEDATALIST_BATCHAPPROVER(@BATCHTEMPLATEID uniqueidentifier = null)
as begin
select ID as VALUE, case when DISPLAYNAME = '' then USERNAME else DISPLAYNAME end as LABEL
from dbo.APPUSER
where dbo.UFN_SECURITY_APPUSER_GRANTED_BATCHAPPROVER(APPUSER.ID, @BATCHTEMPLATEID) = 1
order by LABEL
end