UFN_GRANT_DEADLINES

Returns all deadlines for a given grant.

Return

Return Type
table

Parameters

Parameter Parameter Type Mode Description
@GRANTID uniqueidentifier IN

Definition

Copy


            CREATE function dbo.UFN_GRANT_DEADLINES
            (
                @GRANTID uniqueidentifier
            )
            returns table
            as return
                select
                    ID,
                    GRANTSAWARDEDDATE,
                    BOARDREVIEWSTARTDATE,
                    BOARDREVIEWENDDATE,
                    APPLICATIONDEADLINEDATE
                from 
                    dbo.GRANTDEADLINE
                where    
                    GRANTID = @GRANTID;