USP_SECURITY_SYSTEMROLEFEATUREFOLDER_GET_BUSINESSPROCESSES

                CREATE procedure dbo.USP_SECURITY_SYSTEMROLEFEATUREFOLDER_GET_BUSINESSPROCESSES
                @SYSTEMROLEID uniqueidentifier,
                @ONLYASSIGNED bit = 0

                /*
                Used by the SecurityGetRoleFeaturePermTreeRequest web service

                */
                as

                set nocount on;

                if @SYSTEMROLEID is null 
                    begin
                    raiserror('@SYSTEMROLEID is required',16,10);
                    return 7;
                    end;

                select 
                    CAT.ID,CAT.NAME, 
                    CAT.SECURITYUIFOLDER,
                    PERM.GRANTORDENY,
                    CAT.DESCRIPTION,
                    PERM.ID AS PERMISSIONID,
                    CAT.BUSINESSPROCESSSPECXML as SPECXML
                from 
                    dbo.BUSINESSPROCESSCATALOG as CAT
                left outer join 
                    (
                    select 
                        ID,
                        GRANTORDENY,
                        BUSINESSPROCESSCATALOGID 
                    from  
                        dbo.SYSTEMROLEPERM_BUSINESSPROCESS
                    where 
                        SYSTEMROLEID=@SYSTEMROLEID
                    )
                    as PERM on CAT.ID=PERM.BUSINESSPROCESSCATALOGID

                where  
                    (PERM.ID is not null) or (@ONLYASSIGNED=0)

                order by 
                    CAT.SECURITYUIFOLDER, CAT.NAME;