UFN_PLEDGE_GETPLEDGEFROMPAYMENT
Returns the REVENUEID of a pledge for a REVENUEID of a payment.
Return
| Return Type |
|---|
| uniqueidentifier |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @PAYMENTID | uniqueidentifier | IN |
Definition
Copy
create function dbo.UFN_PLEDGE_GETPLEDGEFROMPAYMENT
(
@PAYMENTID uniqueidentifier
)
returns uniqueidentifier
as
begin
declare @r uniqueidentifier;
select top 1 @r = PLEDGEID from dbo.INSTALLMENTPAYMENT where PAYMENTID = @PAYMENTID;
return @r;
end