SELECT CMP.COMPETENCE_ID ID , CMP.NAME VALUE , CMP.DATE_FROM DATE_FROM , NVL(CMP.DATE_TO , HR_GENERAL.END_OF_TIME) DATE_TO , CMP.BUSINESS_GROUP_ID BUSINESS_GROUP_ID FROM PER_COMPETENCES CMP WHERE TRUNC(SYSDATE) BETWEEN CMP.DATE_FROM AND NVL(CMP.DATE_TO , HR_GENERAL.END_OF_TIME) AND ( CMP.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID , CMP.BUSINESS_GROUP_ID) OR CMP.BUSINESS_GROUP_ID IS NULL) UNION ALL SELECT -1 ID , '' VALUE , HR_GENERAL.START_OF_TIME START_DATE , HR_GENERAL.END_OF_TIME END_DATE , -1 BUSINESS_GROUP_ID FROM DUAL WITH READ ONLY