UFN_APPEALMAILINGTASK_GETREMINDERS

Returns all reminders for a given appeal mailing task record.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@APPEALMAILINGTASKID	uniqueidentifier	IN

Definition

Copy



create function UFN_APPEALMAILINGTASK_GETREMINDERS
(
    @APPEALMAILINGTASKID uniqueidentifier
) returns table as
    return (
        select
            ID,
            NAME,
            SENDDATE,
            SENT
        from
            dbo.APPEALMAILINGTASKREMINDER
        where
            APPEALMAILINGTASKID = @APPEALMAILINGTASKID
    );