USP_DATALIST_CONSTITUENCYREFRESHPROCESS

CREATE procedure dbo.USP_DATALIST_CONSTITUENCYREFRESHPROCESS(@CURRENTAPPUSERID uniqueidentifier = null)
as
begin
    set nocount on;

    select
        [PROCESS].ID,
        [PROCESS].NAME,
        [PROCESS].DESCRIPTION,
        coalesce(IDSETREGISTER.NAME, '') as [SELECTION]
    from dbo.CONSTITUENCYREFRESHPROCESS as [PROCESS]
    left join dbo.IDSETREGISTER on IDSETREGISTER.ID = [PROCESS].IDSETREGISTERID
    where (dbo.UFN_SECURITY_APPUSER_GRANTED_BUSINESSPROCESSINSTANCE_IN_SYSTEMROLE(@CURRENTAPPUSERID, [PROCESS].ID) = 1)
    order by [PROCESS].NAME;
end