UFN_PDACCOUNT_GETEVENTCATEGORY

CREATE function dbo.UFN_PDACCOUNT_GETEVENTCATEGORY
(@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=EVENT.EVENTCATEGORYCODEID
        from dbo.REVENUESPLITORDER
        inner join dbo.EVENT on REVENUESPLITORDER.EVENTID = EVENT.ID
        where REVENUESPLITORDER.ID = @REVENUESPLITID
            and EVENT.PROGRAMID is null;    
    else
        select @RESULT=T0.EVENTCATEGORYCODEID from EVENT T0
        inner join REGISTRANT T1 On T0.ID = T1.EVENTID 
        inner join EVENTREGISTRANTPAYMENT T2 on T1.ID = T2.REGISTRANTID
        where T2.PAYMENTID = @REVENUESPLITID

    return @RESULT

 end