View: HR_H2PI_ELEMENT_LINKS_V

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

View Text

SELECT EL.LAST_UPDATE_DATE
, EL.ELEMENT_LINK_ID
, EL.BUSINESS_GROUP_ID
, EL.EFFECTIVE_START_DATE
, EL.EFFECTIVE_END_DATE
, EL.PAYROLL_ID
, EL.COST_ALLOCATION_KEYFLEX_ID
, EL.ELEMENT_TYPE_ID
, EL.ORGANIZATION_ID
, EL.LOCATION_ID
, EL.PAY_BASIS_ID
, EL.LINK_TO_ALL_PAYROLLS_FLAG
FROM PAY_ELEMENT_LINKS_F EL
, HR_H2PI_ELEMENT_TYPES_V ET
WHERE ET.ELEMENT_TYPE_ID = EL.ELEMENT_TYPE_ID
AND EL.EFFECTIVE_START_DATE BETWEEN ET.EFFECTIVE_START_DATE
AND ET.EFFECTIVE_END_DATE

Columns