View: HR_H2PI_ELEMENT_NAMES_V

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

View Text

SELECT ETTL.LAST_UPDATE_DATE
, ET.BUSINESS_GROUP_ID
, ETTL.ELEMENT_TYPE_ID
, ETTL.ELEMENT_NAME
, ETTL.REPORTING_NAME
FROM PAY_ELEMENT_TYPES_F_TL ETTL
, PAY_ELEMENT_TYPES_F ET
WHERE ET.ELEMENT_TYPE_ID = ETTL.ELEMENT_TYPE_ID
AND ETTL.LAST_UPDATE_DATE BETWEEN ET.EFFECTIVE_START_DATE
AND ET.EFFECTIVE_END_DATE
AND ET.ATTRIBUTE2= 'Y'
AND ETTL.LANGUAGE = 'US'

Columns