UFN_R68_HASPENDINGRECORDS
This function determines whether or not an R68 process status has pending records.
Return
| Return Type |
|---|
| bit |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @BUSINESSPROCESSSTATUSID | uniqueidentifier | IN |
Definition
Copy
create function dbo.UFN_R68_HASPENDINGRECORDS
(
@BUSINESSPROCESSSTATUSID uniqueidentifier
)
returns bit
begin
declare @RET bit = 0;
if exists (select ID from dbo.REVENUESPLITGIFTAID where PENDINGR68STATUSID = @BUSINESSPROCESSSTATUSID)
select @RET = 1;
else
if exists (select ID from dbo.REVENUESPLITGIFTAIDREFUND where PENDINGR68STATUSID = @BUSINESSPROCESSSTATUSID)
select @RET = 1;
return @RET;
end