UFN_CONSTITUENTS_HAVECONFLICTINGDECLARATIONS

The function returns True if the given constituents have one or more conflicting tax declarations.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID1	uniqueidentifier	IN
@CONSTITUENTID2	uniqueidentifier	IN

Definition

Copy



CREATE function dbo.UFN_CONSTITUENTS_HAVECONFLICTINGDECLARATIONS
(
    @CONSTITUENTID1 uniqueidentifier,
    @CONSTITUENTID2 uniqueidentifier
)
returns bit
with execute as caller
as begin

    declare @RET bit = 0;

    if exists(
        select 1
        from dbo.TAXDECLARATION td1
        inner join dbo.TAXDECLARATION td2
            on    (td1.CHARITYCLAIMREFERENCENUMBERID = td2.CHARITYCLAIMREFERENCENUMBERID) or 
                (td1.CHARITYCLAIMREFERENCENUMBERID is null and td2.CHARITYCLAIMREFERENCENUMBERID is null)
        where td1.CONSTITUENTID = @CONSTITUENTID1 and td2.CONSTITUENTID = @CONSTITUENTID2
            and td1.PAYSTAXCODE <> td2.PAYSTAXCODE
            and dbo.UFN_DECLARATIONS_AREDATESOVERLAPPING(td1.DECLARATIONSTARTS, td1.DECLARATIONENDS, td2.DECLARATIONSTARTS, td2.DECLARATIONENDS) = 1
    )
        set @RET = 1;

    return @RET;
end