Query select * from TABELA where DAT_VENCIMENTO BETWEEN TO_DATE(DT_REFERENCIA,'YYYYMMDD') AND LAST_DAY(TO_DATE(DT_REFERENCIA,'YYYYMMDD'))