USP_DATALIST_PAPERLESSMANDATESINSTRUCTIONPROCESSBASIC

Returns a list of Paperless Mandates Instruction 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_PAPERLESSMANDATESINSTRUCTIONPROCESSBASIC
                (
                    @CURRENTAPPUSERID uniqueidentifier = null
                )
                as
                    set nocount on;

                    select
                        PAPERLESSMANDATESINSTRUCTIONPROCESS.ID,
                        PAPERLESSMANDATESINSTRUCTIONPROCESS.NAME,
                        PAPERLESSMANDATESINSTRUCTIONPROCESS.DESCRIPTION,
                        BANKACCOUNT.ACCOUNTNAME  as BANKACCOUNT,
                        BPI.OWNERID as OWNERID
                    from
                        dbo.PAPERLESSMANDATESINSTRUCTIONPROCESS
                        left join dbo.BUSINESSPROCESSINSTANCE BPI 
                            on PAPERLESSMANDATESINSTRUCTIONPROCESS.ID = BPI.BUSINESSPROCESSPARAMETERSETID
                        left join dbo.BANKACCOUNT
                            on PAPERLESSMANDATESINSTRUCTIONPROCESS.BANKACCOUNTID = BANKACCOUNT.ID
                    where 
                        dbo.UFN_SECURITY_APPUSER_GRANTED_BUSINESSPROCESSINSTANCE_IN_SYSTEMROLE(@CURRENTAPPUSERID, PAPERLESSMANDATESINSTRUCTIONPROCESS.ID) = 1
                    order by PAPERLESSMANDATESINSTRUCTIONPROCESS.NAME