UFN_PDACCOUNT_GETEVENTID

CREATE function dbo.UFN_PDACCOUNT_GETEVENTID
(@REVENUESPLITID as uniqueidentifier,
 @REVENUETRANSACTIONTYPECODE as tinyint,
 @APPLICATIONCODE tinyint,
 @PAYMENTMETHODCODE as tinyint,
 @DESIGNATIONID as uniqueidentifier) returns uniqueidentifier
 As 
 begin
    declare @RESULT as uniqueidentifier

    if @APPLICATIONCODE = 10 
        select @RESULT=REVENUESPLITORDER.EVENTID
        from dbo.REVENUESPLITORDER
        inner join dbo.EVENT on REVENUESPLITORDER.EVENTID = EVENT.ID
        where REVENUESPLITORDER.ID = @REVENUESPLITID
            and EVENT.PROGRAMID is null;
    else
        select @RESULT=T2.EVENTID from EVENTREGISTRANTPAYMENT T1
        inner join REGISTRANT T2 on T1.REGISTRANTID=T2.ID 
        where T1.PAYMENTID = @REVENUESPLITID

    return @RESULT

 end