View: HR_H2PI_ELEMENT_ENTRY_VALUES_V

Product:	PER - Human Resources
Description:	Contains data related to Oracle HR to Oracle Payroll Interface (H2PI) for element entry values
Implementation/DBA Data:	APPS.HR_H2PI_ELEMENT_ENTRY_VALUES_V

View Text

SELECT EE.LAST_UPD_DATE
, EE.BUSINESS_GROUP_ID
, EE.ELEMENT_ENTRY_ID
, EE.PERSON_ID
, IV.EFFECTIVE_START_DATE
, IV.EFFECTIVE_END_DATE
, IV.INPUT_VALUE_ID
, IV.SCREEN_ENTRY_VALUE
FROM PAY_ELEMENT_ENTRY_VALUES_F IV
, HR_H2PI_ELEMENT_ENTRIES_V EE
WHERE EE.ELEMENT_ENTRY_ID = IV.ELEMENT_ENTRY_ID
AND IV.EFFECTIVE_START_DATE BETWEEN EE.EFFECTIVE_START_DATE
AND EE.EFFECTIVE_END_DATE

Columns