USP_DATALIST_ADDSTEWARDSHIPPLANSTEPSPROCESS

Returns a list of Add Stewardship Plan Steps 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_ADDSTEWARDSHIPPLANSTEPSPROCESS
(
    @CURRENTAPPUSERID uniqueidentifier = null
)
as
    set nocount on;

    select
        ADDSTEWARDSHIPPLANSTEPSPROCESS.ID,
    ADDSTEWARDSHIPPLANSTEPSPROCESS.NAME,
    ADDSTEWARDSHIPPLANSTEPSPROCESS.DESCRIPTION,
    IDSETREGISTER.NAME,
        BPI.OWNERID as OWNERID                            
    from
        dbo.ADDSTEWARDSHIPPLANSTEPSPROCESS
    left join dbo.IDSETREGISTER on IDSETREGISTER.ID = ADDSTEWARDSHIPPLANSTEPSPROCESS.IDSETREGISTERID
        left join dbo.BUSINESSPROCESSINSTANCE BPI on ADDSTEWARDSHIPPLANSTEPSPROCESS.ID = BPI.BUSINESSPROCESSPARAMETERSETID
    where 
        dbo.UFN_SECURITY_APPUSER_GRANTED_BUSINESSPROCESSINSTANCE_IN_SYSTEMROLE(@CURRENTAPPUSERID, ADDSTEWARDSHIPPLANSTEPSPROCESS.ID) = 1
    order by ADDSTEWARDSHIPPLANSTEPSPROCESS.NAME