USP_EMAIL_GETPROCESSLAUNCHIDS

Returns all business process launch ids for a particular email process type

Parameters

Parameter	Parameter Type	Mode	Description
@GLOBALCHANGECATALOGID	uniqueidentifier	IN

Definition

Copy



      create procedure dbo.USP_EMAIL_GETPROCESSLAUNCHIDS
      (
        @GLOBALCHANGECATALOGID uniqueidentifier
      )
      as
      begin
           set nocount on;

        select BUSINESSPROCESSCATALOGID,BUSINESSPROCESSPARAMETERSETID from BUSINESSPROCESSINSTANCE 
            inner join GLOBALCHANGE GC on BUSINESSPROCESSPARAMETERSETID = GC.ID
            where GLOBALCHANGECATALOGID = @GLOBALCHANGECATALOGID;

      end