UFN_BUSINESSPROCESSCATALOG_GETNAME

            create function dbo.UFN_BUSINESSPROCESSCATALOG_GETNAME(@ID uniqueidentifier)
            returns nvarchar(100)
            with execute as caller
            as
            begin
                declare @NAME nvarchar(60)                
                select @NAME = NAME from dbo.BUSINESSPROCESSCATALOG where ID = @ID                
                return @NAME
            end