UFN_MATCHINGGIFTCONDITIONRELATIONSHIP_UNIQUERELATIONSHIPFORORGANIZATION_2

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode
@MATCHINGGIFTCONDITIONID	uniqueidentifier	IN
@RELATIONSHIPTYPECODEID	uniqueidentifier	IN
@JOBSCHEDULECODEID	uniqueidentifier	IN
@CAREERLEVELCODEID	uniqueidentifier	IN
@ORGANIZATIONID	uniqueidentifier	IN
@REVENUETYPECODE	tinyint	IN

Definition

Copy



create function dbo.UFN_MATCHINGGIFTCONDITIONRELATIONSHIP_UNIQUERELATIONSHIPFORORGANIZATION_2
(
    @MATCHINGGIFTCONDITIONID uniqueidentifier,
    @RELATIONSHIPTYPECODEID uniqueidentifier,
    @JOBSCHEDULECODEID uniqueidentifier,
    @CAREERLEVELCODEID uniqueidentifier,
    @ORGANIZATIONID uniqueidentifier,
    @REVENUETYPECODE tinyint
)
returns bit with execute as caller
as
begin

    if exists(select MATCHINGGIFTCONDITIONRELATIONSHIP.ID from dbo.MATCHINGGIFTCONDITIONRELATIONSHIP
                inner join dbo.MATCHINGGIFTCONDITION on MATCHINGGIFTCONDITION.ID = MATCHINGGIFTCONDITIONRELATIONSHIP.MATCHINGGIFTCONDITIONID
                where MATCHINGGIFTCONDITION.ORGANIZATIONID = @ORGANIZATIONID
                and MATCHINGGIFTCONDITION.ID <> @MATCHINGGIFTCONDITIONID
                and MATCHINGGIFTCONDITION.REVENUETYPECODE = @REVENUETYPECODE
                and MATCHINGGIFTCONDITIONRELATIONSHIP.RELATIONSHIPTYPECODEID = @RELATIONSHIPTYPECODEID
                and ((MATCHINGGIFTCONDITIONRELATIONSHIP.JOBSCHEDULECODEID is null and @JOBSCHEDULECODEID is null) or (MATCHINGGIFTCONDITIONRELATIONSHIP.JOBSCHEDULECODEID = @JOBSCHEDULECODEID))
                and ((MATCHINGGIFTCONDITIONRELATIONSHIP.CAREERLEVELCODEID is null and @CAREERLEVELCODEID is null) or (MATCHINGGIFTCONDITIONRELATIONSHIP.CAREERLEVELCODEID = @CAREERLEVELCODEID)))
        return 0;

    return 1;

end