SELECT PPS.POSITION_STRUCTURE_ID ID , PPS.NAME ||' : '||PSV.VERSION_NUMBER VALUE , PSV.DATE_FROM START_DATE , NVL(PSV.DATE_TO , HR_GENERAL.END_OF_TIME) END_DATE , PSV.BUSINESS_GROUP_ID BUSINESS_GROUP_ID , PPS.PRIMARY_POSITION_FLAG PRIMARY_STRUCTURE_FLAG FROM PER_POSITION_STRUCTURES PPS , PER_POS_STRUCTURE_VERSIONS PSV WHERE PPS.POSITION_STRUCTURE_ID = PSV.POSITION_STRUCTURE_ID AND TRUNC(SYSDATE) BETWEEN PSV.DATE_FROM AND NVL(PSV.DATE_TO , HR_GENERAL.END_OF_TIME) AND PPS.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID , PPS.BUSINESS_GROUP_ID) WITH READ ONLY