USP_PLEDGE_VALIDATE
Adds a payment to a pledge.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @PLEDGEID | uniqueidentifier | IN |
Definition
Copy
CREATE procedure dbo.USP_PLEDGE_VALIDATE (@PLEDGEID uniqueidentifier)
as
begin
declare @ISMEMBERSHIPPLEDGE bit;
select @ISMEMBERSHIPPLEDGE = case when FINANCIALTRANSACTION.TYPECODE = 15 then 1 else 0 end
from dbo.FINANCIALTRANSACTION
where ID = @PLEDGEID
exec dbo.USP_PLEDGE_VALIDATE_2 @PLEDGEID
,@ISMEMBERSHIPPLEDGE;
end