Rates are not appearing based on Effective as of Date

In UDT we have updated values, but based on effective date not appearing correctly.

FROM Clause - FF_USER_TABLES FUT, FF_USER_TABLES_TL FUTT, FF_USER_COLUMNS FUC, FF_USER_COLUMNS_TL FUCT, FF_USER_ROWS_F FURF, FF_USER_ROWS_TL FURT, FF_USER_COLUMN_INSTANCES_F FUCIF

WHERE Clause -FUT.USER_TABLE_ID = FUTT.USER_TABLE_ID

   AND FUT.USER_TABLE_ID = FUC.USER_TABLE_ID

   AND FUC.USER_COLUMN_ID = FUCT.USER_COLUMN_ID

   AND FUT.USER_TABLE_ID = FURF.USER_TABLE_ID

   AND FURF.USER_ROW_ID = FURT.USER_ROW_ID

   AND FURF.USER_ROW_ID = FUCIF.USER_ROW_ID