UFN_SITEID_MAPFROM_FUNDINGREQUESTOUTLINEID

Maps a plan outline ID to a site ID

Return

Return Type
uniqueidentifier

Parameters

Parameter Parameter Type Mode Description
@FUNDINGREQUESTOUTLINEID uniqueidentifier IN

Definition

Copy


            create function dbo.UFN_SITEID_MAPFROM_FUNDINGREQUESTOUTLINEID(
                @FUNDINGREQUESTOUTLINEID uniqueidentifier
            )
            returns uniqueidentifier
            as
            begin

            declare @SITEID uniqueidentifier

            select @SITEID=SITEID
            from dbo.FUNDINGREQUESTOUTLINE
            where ID=@FUNDINGREQUESTOUTLINEID

            return @SITEID

            end