UFN_SPONSORSHIP_GETACTIVEFINANCIALCOMMITMENTFORSPONSOR
Counts the active financial commitments for a sponsor
Return
| Return Type |
|---|
| int |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SPONSORID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.UFN_SPONSORSHIP_GETACTIVEFINANCIALCOMMITMENTFORSPONSOR
(
@SPONSORID uniqueidentifier
)
returns int
with execute as caller
as begin
declare @COUNT int =0;
select @COUNT = COUNT(*)
from dbo.SPONSORSHIP sp
inner join dbo.FINANCIALTRANSACTIONLINEITEM ftli on ftli.ID = sp.REVENUESPLITID
inner join dbo.FINANCIALTRANSACTION ft on ft.ID = ftli.FINANCIALTRANSACTIONID
where ft.CONSTITUENTID = @SPONSORID
and ft.DELETEDON is null
and sp.STATUSCODE = 1;
return @COUNT
end