UFN_SITEID_MAPFROM_FUNDINGREQUESTMEDIALINKID

            create function dbo.UFN_SITEID_MAPFROM_FUNDINGREQUESTMEDIALINKID
            (
                @FUNDINGREQUESTMEDIALINKID uniqueidentifier
            )
            returns uniqueidentifier
            as
            begin

            declare @SITEID uniqueidentifier

            select 
                @SITEID = FUNDINGPLAN.SITEID
            from 
                dbo.FUNDINGPLAN
                inner join dbo.FUNDINGREQUEST on FUNDINGREQUEST.FUNDINGPLANID = FUNDINGPLAN.ID
                inner join dbo.FUNDINGREQUESTMEDIALINK on FUNDINGREQUESTMEDIALINK.FUNDINGREQUESTID = FUNDINGREQUEST.ID
            where 
                FUNDINGREQUESTMEDIALINK.ID = @FUNDINGREQUESTMEDIALINKID;

            return @SITEID;

            end