VIEW: APPS.GHR_ELEMENT_ENTRIES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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