UFN_MKTSEGMENTATION_GETSELECTEDSOLICITCODEEXCLUSIONS
Returns all required solicit codes along with the solicit codes selected for a particular marketing effort activate process.
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SEGMENTATIONACTIVATEPROCESSID | uniqueidentifier | IN |
Definition
Copy
create function dbo.[UFN_MKTSEGMENTATION_GETSELECTEDSOLICITCODEEXCLUSIONS]
(
@SEGMENTATIONACTIVATEPROCESSID uniqueidentifier
)
returns table
as
return
select
[ID],
[SOLICITCODEID],
convert(bit, 0) as [REQUIRED]
from dbo.[UFN_BUSINESSPROCESSCOMMPREF_GETEXCLUSIONS](@SEGMENTATIONACTIVATEPROCESSID);