SELECT DISTINCT RPST.ID RESP_SET_ID , RPST.NAME RESP_SET_NAME FROM OKR_RESP_VALUES_B RPVB , OKR_RESP_VALUES_TL RPVT , OKR_PROP_RESP_SET_B RPSB , OKR_PROP_RESP_SET_TL RPST WHERE RPVB.ID = RPVT.ID AND RPVT.LANGUAGE = USERENV('LANG') AND RPVB.RESP_SET_ID = RPST.ID AND RPST.ID = RPSB.ID AND RPST.LANGUAGE = USERENV('LANG') AND SYSDATE BETWEEN NVL(RPVB.START_DATE_ACTIVE , SYSDATE) AND NVL(RPVB.END_DATE_ACTIVE , SYSDATE) AND SYSDATE BETWEEN NVL(RPSB.START_DATE_ACTIVE , SYSDATE) AND NVL(RPSB.END_DATE_ACTIVE , SYSDATE)