USP_GLOBALCHANGE_GETINSTANCEINFORMATION

            CREATE procedure dbo.USP_GLOBALCHANGE_GETINSTANCEINFORMATION
            (
                @ID uniqueidentifier
            )
            as
                select
                    GLOBALCHANGE.NAME,
                    GLOBALCHANGE.GLOBALCHANGEDATAFORMITEM,
                    GLOBALCHANGE.TSLONG,
                    GLOBALCHANGECATALOG.DISPLAYNAME,
                    GLOBALCHANGECATALOG.FORMMETADATAXML,
                    BPI.OWNERID,
                    BPI.SITEID,
          GLOBALCHANGECATALOG.GLOBALCHANGESPECXML
                from dbo.GLOBALCHANGE
                    inner join dbo.GLOBALCHANGECATALOG on GLOBALCHANGECATALOG.ID = GLOBALCHANGE.GLOBALCHANGECATALOGID
                    left join dbo.BUSINESSPROCESSINSTANCE BPI on BPI.BUSINESSPROCESSPARAMETERSETID = GLOBALCHANGE.ID
                where
                    GLOBALCHANGE.ID = @ID;