View: GHR_ELEMENT_ENTRIES_V

Product:	GHR - US Federal Human Resources
Description:	This view holds the Element Entries info for GHR Elements
Implementation/DBA Data:	APPS.GHR_ELEMENT_ENTRIES_V

View Text

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

Columns