USP_DATALIST_ADDREQUESTSFORMULTIPLESTUDENTSPROCESS

Returns a list of Globally Add Requests Business process parameter sets.

Parameters

Parameter	Parameter Type	Mode	Description
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.

Definition

Copy



CREATE procedure dbo.USP_DATALIST_ADDREQUESTSFORMULTIPLESTUDENTSPROCESS
(
    @CURRENTAPPUSERID uniqueidentifier = null
)
as
set nocount on

select
    ADDREQUESTSFORMULTIPLESTUDENTSPROCESS.ID,
    ADDREQUESTSFORMULTIPLESTUDENTSPROCESS.NAME,
    ADDREQUESTSFORMULTIPLESTUDENTSPROCESS.DESCRIPTION,
    dbo.UFN_ADDREQUESTSFORMULTIPLESTUDENTS_GETCORELIST(ADDREQUESTSFORMULTIPLESTUDENTSPROCESS.ID) AS CORE_LIST                
from
    dbo.ADDREQUESTSFORMULTIPLESTUDENTSPROCESS
    left join dbo.BUSINESSPROCESSINSTANCE BPI on ADDREQUESTSFORMULTIPLESTUDENTSPROCESS.ID = BPI.BUSINESSPROCESSPARAMETERSETID
where 
    dbo.UFN_SECURITY_APPUSER_GRANTED_BUSINESSPROCESSINSTANCE_IN_SYSTEMROLE(@CURRENTAPPUSERID, ADDREQUESTSFORMULTIPLESTUDENTSPROCESS.ID) = 1
order by ADDREQUESTSFORMULTIPLESTUDENTSPROCESS.NAME