UFN_SITEID_MAPFROM_FUNDINGPLANID
Maps a funding plan ID to a site ID
Return
| Return Type |
|---|
| uniqueidentifier |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @FUNDINGPLANID | uniqueidentifier | IN |
Definition
Copy
create function dbo.UFN_SITEID_MAPFROM_FUNDINGPLANID
(
@FUNDINGPLANID uniqueidentifier
)
returns uniqueidentifier
as
begin
declare @SITEID uniqueidentifier
select
@SITEID = SITEID
from
dbo.FUNDINGPLAN
where
ID = @FUNDINGPLANID;
return @SITEID;
end