USP_APPEALMAILING_GETACTIVATEPROCESSSTATUSIDS
Retrieves the segmentation activate process status ids for the segmentation.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SEGMENTATIONID | uniqueidentifier | IN |
Definition
Copy
create procedure dbo.USP_APPEALMAILING_GETACTIVATEPROCESSSTATUSIDS
(
@SEGMENTATIONID uniqueidentifier
)
as
select
MKTSEGMENTATIONACTIVATEPROCESSSTATUS.ID
from
MKTSEGMENTATIONACTIVATEPROCESSSTATUS
inner join
MKTSEGMENTATIONACTIVATEPROCESS on MKTSEGMENTATIONACTIVATEPROCESS.ID = MKTSEGMENTATIONACTIVATEPROCESSSTATUS.PARAMETERSETID
where
MKTSEGMENTATIONACTIVATEPROCESS.SEGMENTATIONID = @SEGMENTATIONID