UFN_PDACCOUNT_GETMEMBERSHIPLEVEL_3

Return

Return Type
uniqueidentifier

Parameters

Parameter	Parameter Type	Mode	Description
@REVENUESPLITINFORMATION	xml	IN

Definition

Copy



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

                select @RESULT = REVENUESPLITINFORMATION.MEMBERSHIPLEVELID  
                from dbo.UFN_REVENUESPLITINFORMATION_FROMITEMLISTXML(@REVENUESPLITINFORMATION) as REVENUESPLITINFORMATION;

                if ((select REVENUESPLITINFORMATION.APPLICATIONCODE
                    from dbo.UFN_REVENUESPLITINFORMATION_FROMITEMLISTXML(@REVENUESPLITINFORMATION) as REVENUESPLITINFORMATION) = 10) and
                    (@RESULT is null) -- order payment 

                    select @RESULT = REVENUESPLITINFORMATION.ORDERMEMBERSHIPLEVELID 
                    from dbo.UFN_REVENUESPLITINFORMATION_FROMITEMLISTXML(@REVENUESPLITINFORMATION) as REVENUESPLITINFORMATION;

                return @RESULT;
            end