SELECT OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKC_RULE_GROUP_DEF' , SRDV.RGD_CODE , 510 , 0) MEANING , SRDV.RGD_CODE RGD_CODE , SRDV.SCS_CODE FROM OKC_SUBCLASS_RG_DEFS SRDV , OKC_SUBCLASSES_B SCSV WHERE SRDV.SCS_CODE = SCSV.CODE AND SYSDATE BETWEEN SCSV.START_DATE AND NVL(SCSV.END_DATE , SYSDATE) AND SYSDATE BETWEEN SRDV.START_DATE AND NVL(SRDV.END_DATE , SYSDATE)