SELECT BBT.BALANCE_TYPE_ID , INV.NAME , PET.ELEMENT_NAME , PET.REPORTING_NAME , PET.OUTPUT_CURRENCY_CODE , INV.UOM , INV.INPUT_VALUE_ID , PET.ELEMENT_TYPE_ID FROM PAY_ELEMENT_TYPES_F PET , PAY_INPUT_VALUES_F INV , PER_BF_BALANCE_TYPES BBT WHERE BBT.INPUT_VALUE_ID = INV.INPUT_VALUE_ID AND INV.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID AND TRUNC(SYSDATE) BETWEEN INV.EFFECTIVE_START_DATE AND INV.EFFECTIVE_END_DATE AND TRUNC(SYSDATE) BETWEEN PET.EFFECTIVE_START_DATE AND PET.EFFECTIVE_END_DATE WITH READ ONLY