UFN_SITEID_MAPFROM_FUNDINGREQUESTSTEPID

            create function dbo.UFN_SITEID_MAPFROM_FUNDINGREQUESTSTEPID
            (
                @FUNDINGREQUESTSTEPID 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.INTERACTION on INTERACTION.FUNDINGREQUESTID = FUNDINGREQUEST.ID
                where INTERACTION.ID = @FUNDINGREQUESTSTEPID;

                return @SITEID;

            end