View: HR_H2PI_INPUT_VALUES_V

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

View Text

SELECT ET.LAST_UPD_DATE
, ET.BUSINESS_GROUP_ID
, ET.ELEMENT_TYPE_ID
, IV.EFFECTIVE_START_DATE
, IV.EFFECTIVE_END_DATE
, IV.INPUT_VALUE_ID
, IV.NAME
, IV.LEGISLATION_CODE
, IV.UOM
, IV.MANDATORY_FLAG
, IV.DEFAULT_VALUE
, IV.LOOKUP_TYPE
FROM PAY_INPUT_VALUES_F IV
, HR_H2PI_ELEMENT_TYPES_V ET
WHERE ET.ELEMENT_TYPE_ID = IV.ELEMENT_TYPE_ID
AND IV.EFFECTIVE_START_DATE BETWEEN ET.EFFECTIVE_START_DATE
AND ET.EFFECTIVE_END_DATE

Columns