USP_RESEARCHGROUPPOPULATEPROCESS_GETPARAMETERS

            create procedure dbo.USP_RESEARCHGROUPPOPULATEPROCESS_GETPARAMETERS (
                @ID uniqueidentifier = null
            ) as
                set nocount on;

                select    
                    RGPP.NAME,
                    RGPP.DESCRIPTION,
                    RGPP.RESEARCHGROUPID,
                    RGPP.IDSETREGISTERID,
                    RGPP.POPULATEMETHODCODE,
                    RGPP.CREATEOUTPUTIDSET,
                    RGPP.OUTPUTIDSETNAME,
                    RGPP.OVERWRITEOUTPUTIDSET,
                    cast(case when (
                            RG.OTHERSCANMODIFY = 1 or
                            RG.OWNERID = BPI.OWNERID or
                            RG.OWNERID is null or
                            dbo.UFN_APPUSER_ISSYSADMIN(BPI.OWNERID) = 1) then 1
                            else 0
                            end as bit) USERCANMODIFY
                from dbo.RESEARCHGROUPPOPULATEPROCESS RGPP
                left join dbo.RESEARCHGROUP RG on RG.ID = RGPP.RESEARCHGROUPID
                left join dbo.BUSINESSPROCESSINSTANCE BPI on RGPP.ID = BPI.BUSINESSPROCESSPARAMETERSETID
                where
                    RGPP.ID = @ID;