UFN_R68_CLAIMNUMBERHASBEENCOMMITTED

This function returns true if the given tax claim number has been committed by an R68 process for the given charity claim reference number.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@CHARITYCLAIMREFERENCENUMBER	nvarchar(20)	IN
@TAXCLAIMNUMBER	nvarchar(10)	IN

Definition

Copy



create function dbo.UFN_R68_CLAIMNUMBERHASBEENCOMMITTED
(
    @CHARITYCLAIMREFERENCENUMBER nvarchar(20),
    @TAXCLAIMNUMBER nvarchar(10)
)
returns bit
with execute as caller
as begin

    declare @USED bit = 0;

    if exists(
            select ID 
            from dbo.R68ARCHIVEDPARAMETERS 
            where REFERENCENUMBER = @CHARITYCLAIMREFERENCENUMBER
                and TAXCLAIMNUMBER = @TAXCLAIMNUMBER
                and COMMITTED = 1)
        set @USED = 1;

    return @USED;

end