SELECT PET.ELEMENT_TYPE_ID , PET.START_DATE_ACTIVE , PET.END_DATE_ACTIVE , PET.COMMENTS , PET.LAST_UPDATE_DATE , PET.LAST_UPDATED_BY , PET.CREATED_BY , PET.CREATION_DATE , PTF.ELEMENT_NAME FROM PSP_ELEMENT_TYPES PET , PAY_ELEMENT_TYPES_F PTF WHERE PET.ELEMENT_TYPE_ID = PTF.ELEMENT_TYPE_ID AND PET.START_DATE_ACTIVE BETWEEN PTF.EFFECTIVE_START_DATE AND PTF.EFFECTIVE_END_DATE WITH READ ONLY