USP_APPEALMAILINGREFRESHPROCESS_ACTIVATEDMAILINGS_GETINFO

Gets activated mailings associated with a communication plan.

Parameters

Parameter	Parameter Type	Mode	Description
@SEGMENTEDAPPEALMAILINGREFRESHPROCESSID	uniqueidentifier	IN

Definition

Copy



create procedure dbo.USP_APPEALMAILINGREFRESHPROCESS_ACTIVATEDMAILINGS_GETINFO
(
    @SEGMENTEDAPPEALMAILINGREFRESHPROCESSID uniqueidentifier
)
as begin
    set nocount on;

    select
        ID
    from
        dbo.MKTSEGMENTATIONREFRESHPROCESS
    where
        SEGMENTATIONID in (
            select
                ID
            from
                dbo.COMMUNICATIONPLANMAILING
            where
                COMMUNICATIONPLANID = (
                    select
                        COMMUNICATIONPLANID
                    from
                        dbo.SEGMENTEDAPPEALMAILINGREFRESHPROCESS
                    where
                        ID = @SEGMENTEDAPPEALMAILINGREFRESHPROCESSID                
                )
            )

    return 0; 
end