Query to get User Values from UDTs

Query to get user values from UDTs

 
SELECT pur.row_low_range_or_name, pucif.value
FROM pay_user_column_instances_f pucif
,pay_user_rows_f pur
,pay_user_columns puc
,pay_user_tables put
WHERE put.user_table_id = puc.user_table_id
AND put.user_table_id = pur.user_table_id
AND pucif.user_row_id = pur.user_row_id
AND pucif.user_column_id = puc.user_column_id
AND trunc(SYSDATE) BETWEEN pur.effective_start_date
AND pur.effective_end_date
AND trunc(SYSDATE) BETWEEN pucif.effective_start_date
AND pucif.effective_end_date
AND puc.user_column_name = 'XXXXXX'
AND put.user_table_name = 'XX_APPLICATION_EXCEPTIONS';