UFN_REMINDER_GETLASTREMINDERSENTDATE
Returns the last reminder date.
Return
| Return Type |
|---|
| datetime |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @REVENUEID | uniqueidentifier | IN | |
| @TRANSACTIONTYPECODE | tinyint | IN |
Definition
Copy
CREATE function dbo.UFN_REMINDER_GETLASTREMINDERSENTDATE(
@REVENUEID uniqueidentifier,
@TRANSACTIONTYPECODE tinyint
)
returns datetime
with execute as caller
as begin
declare @REMINDERDATE datetime
select @REMINDERDATE = max(AMOUNTDUEDATE) from dbo.PLEDGEREMINDERSENT
inner join dbo.FINANCIALTRANSACTION on FINANCIALTRANSACTION.ID = PLEDGEREMINDERSENT.REVENUEID
where FINANCIALTRANSACTION.ID = @REVENUEID and FINANCIALTRANSACTION.TYPECODE=@TRANSACTIONTYPECODE
and FINANCIALTRANSACTION.DELETEDON is null
return @REMINDERDATE
end