USP_DATALIST_ADDPROSPECTPLANSPROCESS

Returns a list of saved parameter sets for the Add Prospect Plans process.

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_ADDPROSPECTPLANSPROCESS(@CURRENTAPPUSERID uniqueidentifier = null)
as
    set nocount on;

    select
        [PROCESS].ID,
        [PROCESS].NAME,
        [PROCESS].DESCRIPTION,
        IDSETREGISTER.NAME,
        [PROCESS].PROSPECTPLANNAME,
        PROSPECTPLANTYPECODE.DESCRIPTION,
        BPI.OWNERID as OWNERID
    from dbo.ADDPROSPECTPLANSPROCESS as [PROCESS]
    left join dbo.IDSETREGISTER on IDSETREGISTER.ID = [PROCESS].IDSETREGISTERID
    left join dbo.PROSPECTPLANTYPECODE on PROSPECTPLANTYPECODE.ID = [PROCESS].PROSPECTPLANTYPECODEID
    left join dbo.BUSINESSPROCESSINSTANCE BPI on [PROCESS].ID = BPI.BUSINESSPROCESSPARAMETERSETID
    where (dbo.UFN_SECURITY_APPUSER_GRANTED_BUSINESSPROCESSINSTANCE_IN_SYSTEMROLE(@CURRENTAPPUSERID, [PROCESS].ID) = 1)
    order by [PROCESS].NAME;