USP_DATALIST_UPDATECONSTITUENTSFROMMFO

                create procedure dbo.USP_DATALIST_UPDATECONSTITUENTSFROMMFO
                (
                    @CURRENTAPPUSERID uniqueidentifier = null
                )
                as
                set nocount on;

                select
                    [PROCESS].ID,
                    [PROCESS].NAME,
                    [PROCESS].DESCRIPTION,
                    case 
                        when [PROCESS].CONSTITUENTSELECTIONID is null then N'' 
                        else (select NAME from dbo.IDSETREGISTER where IDSETREGISTER.ID = [PROCESS].CONSTITUENTSELECTIONID) end, 
                    case 
                        when LIMITRECORDSINBATCH = 0 then N'' 
                        else cast (MAXRECORDSINBATCH as nvarchar(100)) end,
                    dbo.UFN_APPUSER_GETNAME([PROCESS].BATCHOWNERID) as [BATCHOWNER],
                    [BPI].OWNERID
                from dbo.UPDATEMULTIPLECONSTITUENTFROMMFOPROCESS as [PROCESS]
                left join dbo.BUSINESSPROCESSINSTANCE as [BPI] on [PROCESS].ID = [BPI].BUSINESSPROCESSPARAMETERSETID
                where (dbo.UFN_SECURITY_APPUSER_GRANTED_BUSINESSPROCESSINSTANCE_IN_SYSTEMROLE(@CURRENTAPPUSERID, [PROCESS].ID) = 1)
                order by [PROCESS].NAME;