UFN_SITEID_MAPFROM_BUSINESSPROCESSSTATUSID

            create function dbo.UFN_SITEID_MAPFROM_BUSINESSPROCESSSTATUSID(
                @BUSINESSPROCESSSTATUSID uniqueidentifier
            )
            returns @SITES table (SITEID uniqueidentifier)
            as
            begin

                declare @BUSINESSPROCESSINSTANCEID uniqueidentifier

                select @BUSINESSPROCESSINSTANCEID = BUSINESSPROCESSINSTANCE.ID
                from dbo.BUSINESSPROCESSSTATUS
                    inner join dbo.BUSINESSPROCESSINSTANCE 
                        on BUSINESSPROCESSINSTANCE.BUSINESSPROCESSCATALOGID = BUSINESSPROCESSSTATUS.BUSINESSPROCESSCATALOGID
                            and BUSINESSPROCESSINSTANCE.BUSINESSPROCESSPARAMETERSETID = BUSINESSPROCESSSTATUS.BUSINESSPROCESSPARAMETERSETID
                where BUSINESSPROCESSSTATUS.ID = @BUSINESSPROCESSSTATUSID

                insert into @SITES (SITEID)
                select SITEID from dbo.UFN_SITEID_MAPFROM_BUSINESSPROCESSINSTANCEID(@BUSINESSPROCESSINSTANCEID)

                return;

            end