UFN_BUSINESSPROCESS_GETNAME

            create function dbo.UFN_BUSINESSPROCESS_GETNAME (@ID as uniqueidentifier)
            returns nvarchar(60)
            with execute as caller
            as
            begin
                declare @name nvarchar(60)
                set @name=N''
                select @name = [NAME] from dbo.BUSINESSPROCESSCATALOG where ID = @ID
                return @name
            end