UFN_FUNDINGREQUEST_GETNAME

            CREATE function dbo.UFN_FUNDINGREQUEST_GETNAME
            (
                @ID uniqueidentifier
            ) 
            returns nvarchar(100) 
            with execute as caller
            as
            begin
                declare @NAME nvarchar(100)

                select 
                    @NAME = FUNDINGPLAN.NAME 
                from 
                    dbo.FUNDINGREQUEST
                    inner join dbo.FUNDINGPLAN on FUNDINGREQUEST.FUNDINGPLANID = FUNDINGPLAN.ID
                where 
                    FUNDINGREQUEST.ID = @ID

                return @NAME
            end