PROCEDURE PESQUISA_HABILITACOES_A_VENCER(p_DIAS_INICIAL IN NUMBER,
                                         p_DIAS_FINAL IN NUMBER,
                                         p_DATABASE IN DATE,
                                         p_Cursor OUT SYS_REFCURSOR) IS
  BEGIN

    OPEN p_Cursor FOR
      SELECT cert.tcg_rge_ruc, LAST_DAY(TO_DATE(cert.tcg_periodo_fim,'YYYYMM')) AS "VENC_HABILITA"
       FROM tab_certif_graf cert
      WHERE TRUNC(LAST_DAY(TO_DATE(cert.tcg_periodo_fim,'YYYYMM')) - TRUNC(p_DATABASE)) > p_DIAS_INICIAL
      AND TRUNC(LAST_DAY(TO_DATE(cert.tcg_periodo_fim,'YYYYMM')) - TRUNC(p_DATABASE)) < p_DIAS_FINAL;
END;