UFN_PDACCOUNT_GETEVENTID_3

Return

Return Type
uniqueidentifier
Parameters

Parameter	Parameter Type	Mode	Description
@REVENUESPLITINFORMATION	xml	IN
Definition

Copy


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

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

                return @RESULT;
            end