USP_DATALIST_GRANTDEADLINE
Returns a list of all deadlines associated with a given grant.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @GRANTID | uniqueidentifier | IN | Input parameter indicating the context ID for the data list. |
Definition
Copy
CREATE procedure dbo.USP_DATALIST_GRANTDEADLINE
(
@GRANTID uniqueidentifier
)
as
set nocount on;
select
ID,
GRANTSAWARDEDDATE,
BOARDREVIEWSTARTDATE,
BOARDREVIEWENDDATE,
APPLICATIONDEADLINEDATE
from
dbo.GRANTDEADLINE
where
GRANTID = @GRANTID
order by
GRANTSAWARDEDDATE
return 0;