UFN_PDACCOUNT_GETEVENTCATEGORY_3

Return

Return Type
uniqueidentifier
Parameters

Parameter	Parameter Type	Mode	Description
@REVENUESPLITINFORMATION	xml	IN
Definition

Copy


            create function dbo.UFN_PDACCOUNT_GETEVENTCATEGORY_3
            (
                @REVENUESPLITINFORMATION xml 
            ) returns uniqueidentifier
            As 
            begin
                declare @RESULT as uniqueidentifier;

                if ((select REVENUESPLITINFORMATION.APPLICATIONCODE
                    from dbo.UFN_REVENUESPLITINFORMATION_FROMITEMLISTXML(@REVENUESPLITINFORMATION) as REVENUESPLITINFORMATION) = 10)
                    select @RESULT = EVENT.EVENTCATEGORYCODEID
                    from dbo.UFN_REVENUESPLITINFORMATION_FROMITEMLISTXML(@REVENUESPLITINFORMATION) as REVENUESPLITINFORMATION
                        inner join dbo.EVENT 
                            on REVENUESPLITINFORMATION.EVENTID = EVENT.ID
                    where (EVENT.PROGRAMID is null);

                else
                    select @RESULT = EVENT.EVENTCATEGORYCODEID
                    from dbo.UFN_REVENUESPLITINFORMATION_FROMITEMLISTXML(@REVENUESPLITINFORMATION) as REVENUESPLITINFORMATION
                        inner join dbo.EVENT 
                            on REVENUESPLITINFORMATION.EVENTID = EVENT.ID;

                return @RESULT;

            end