UFN_PLANNEDGIFT_ISDEFERRED
Determines if a given planned gift is deferred.
Return
| Return Type |
|---|
| bit |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @PLANNEDGIFTID | uniqueidentifier | IN |
Definition
Copy
create function dbo.UFN_PLANNEDGIFT_ISDEFERRED
(
@PLANNEDGIFTID uniqueidentifier
)
returns bit
with execute as caller
as begin
declare @EXISTS bit;
if exists(
select
PAYMENTID
from
dbo.INSTALLMENTPAYMENT
inner join dbo.INSTALLMENT on INSTALLMENTPAYMENT.INSTALLMENTID = INSTALLMENT.ID
inner join dbo.REVENUE on INSTALLMENT.REVENUEID = REVENUE.ID
inner join dbo.PLANNEDGIFTREVENUE on REVENUE.ID = PLANNEDGIFTREVENUE.REVENUEID
where
PLANNEDGIFTREVENUE.ID = @PLANNEDGIFTID
) set @EXISTS = 1
else
set @EXISTS = 0
return @EXISTS;
end