UFN_FUNDINGREQUEST_INACTIVE

Uses a funding request's funding plan to determine whether or not the request is active.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@FUNDINGREQUESTID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_FUNDINGREQUEST_INACTIVE(@FUNDINGREQUESTID uniqueidentifier)
            returns bit
            with execute as caller
            as begin
                declare @INACTIVE bit = 0

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

                return @INACTIVE
            end