Issues with LP_TICKET_ELEMENTS

I have set up user defined elements in LP_TICKET_ELEMENTS using IF statements like the following:

If @ude_no = 1

      and @customer_no > 0

      and @design_type = 'H'

      and @li_seq_no in

                  (

                        select li_seq_no

                        from T_SUB_LINEITEM

                        where price_type in ('235', '347', '266')

                  )

      BEGIN

            Select      @ude_value = IsNull(a.inputName, '')

            From NYSF_SITP_VLINE_ENTRIES a

            Where a.customer_no = @customer_no

      END

Else

      If @ude_no = 1

            and @customer_no > 0

            and @design_type = 'H'

            and (

                  @li_seq_no is null or @li_seq_no not in

                        (

                              select li_seq_no

                              from T_SUB_LINEITEM

                              where price_type in ('235', '347', '266')

                        )

                  )

      BEGIN

            Select @ude_value = IsNull(lname, '')

            from T_CUSTOMER

            where customer_no = @customer_no

When I execute this from within SQL using these parameters

      @ude_no

      @li_seq_no

      @customer_no

      @design_type

it outputs correctly. However when I print a ticket-header (with tickets, so a li_seq_no is provided) from within Tessitura for a customer that has one of the price types mentioned in the first IF statement, it outputs as if they belong to the ‘Else’ group.

I ran a trace and found that LP_TICKET_ELEMENTS is called from TP_GET_HEADER_ELEMENTS, but after looking through this procedure I can’t see anything I have done (or haven’t done) in LP_TICKET_ELEMENTS that would cause this behavior. TP_GET_HEADER_ELEMENTS asks for a third parameter @au_set_no that is not being provided but I’m not sure what it actually is.

Does anyone have any ideas? I hope I have made sense. Totally baffled….