SELECT ELT.ELEMENT_NAME , ELE.ELEMENT_ENTRY_ID , ELE.EFFECTIVE_START_DATE , ELE.EFFECTIVE_END_DATE , ELE.ASSIGNMENT_ID FROM PAY_ELEMENT_ENTRIES_F ELE , PAY_ELEMENT_LINKS_F ELL , PAY_ELEMENT_TYPES_F ELT , FND_SESSIONS SES WHERE USERENV('SESSIONID') = SES.SESSION_ID AND SES.EFFECTIVE_DATE BETWEEN ELE.EFFECTIVE_START_DATE AND ELE.EFFECTIVE_END_DATE AND ELE.ELEMENT_LINK_ID = ELL.ELEMENT_LINK_ID AND SES.EFFECTIVE_DATE BETWEEN ELL.EFFECTIVE_START_DATE AND ELL.EFFECTIVE_END_DATE AND ELL.ELEMENT_TYPE_ID = ELT.ELEMENT_TYPE_ID AND SES.EFFECTIVE_DATE BETWEEN ELT.EFFECTIVE_START_DATE AND ELT.EFFECTIVE_END_DATE