UFN_SITEID_MAPFROM_BUSINESSPROCESSINSTANCEID

            create function dbo.UFN_SITEID_MAPFROM_BUSINESSPROCESSINSTANCEID(
                @BUSINESSPROCESSINSTANCEID uniqueidentifier
            )
            returns @SITES table (SITEID uniqueidentifier)
            as
            begin

                insert into @SITES(SITEID)
                select SITEID
                from dbo.BUSINESSPROCESSINSTANCE
                where ID=@BUSINESSPROCESSINSTANCEID

                if (select count(SITEID) from @SITES) = 0 --If no site has been assigned, then the process is unsecured and available to all sites.

                    begin
                        insert into @SITES(SITEID)
                        values(null)

                        insert into @SITES(SITEID)
                        select ID
                        from SITE
                    end

                return;

            end