USP_APPEALMAILING_GETEMAILJOBSTATUSIDS
Retrieves the email status ids associated with the given appeal mailing.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @APPEALMAILINGID | uniqueidentifier | IN |
Definition
Copy
CREATE procedure dbo.USP_APPEALMAILING_GETEMAILJOBSTATUSIDS
(
@APPEALMAILINGID uniqueidentifier
)
as begin
select
COMMUNICATIONLETTER.EMAILSTATUSID
from
COMMUNICATIONLETTER
where
COMMUNICATIONLETTER.SEGMENTATIONID = @APPEALMAILINGID
and
COMMUNICATIONLETTER.EMAILSTATUSID is not null
end