Query to get values from the User Defined Tables (UDT) in Oracle APPS

SELECT pui.value, puc.user_column_name, pur.row_low_range_or_name

  FROM pay_user_tables put

      ,pay_user_rows_f pur

  ,pay_user_columns puc

  ,pay_user_column_instances_f pui

 WHERE pur.user_table_id = put.user_table_id

   AND pui.user_column_id = puc.user_column_id

   AND pui.user_row_id = pur.user_row_id

   AND SYSDATE BETWEEN pur.effective_start_date AND pur.effective_end_date

   AND SYSDATE BETWEEN pui.effective_start_date AND pui.effective_end_date

   AND puc.user_table_id = put.user_table_id   

   AND put.user_table_name = 'XX_UDT_NAME'

   AND puc.user_column_name = 'XX_COLUMN_NAME'