USP_DATALIST_ADDSTEWARDSHIPPLANSPROCESS

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

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