SELECT GRD.GRADE_ID ID , GRD.NAME VALUE , GRD.DATE_FROM DATE_FROM , NVL(GRD.DATE_TO , HR_GENERAL.END_OF_TIME) DATE_TO , GRD.BUSINESS_GROUP_ID BUSINESS_GROUP_ID FROM PER_GRADES GRD WHERE TRUNC(SYSDATE) BETWEEN GRD.DATE_FROM AND NVL(GRD.DATE_TO , HR_GENERAL.END_OF_TIME) AND GRD.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID , GRD.BUSINESS_GROUP_ID) UNION ALL SELECT -1 ID , '' VALUE , HR_GENERAL.START_OF_TIME DATE_FROM , HR_GENERAL.END_OF_TIME DATE_TO , -1 BUSINESS_GROUP_ID FROM DUAL WITH READ ONLY