[Home] [Help]
View: HR_H2PI_ELEMENT_TYPES_V
Product: | PER - Human Resources |
Description: | Contains data related to Oracle HR to Oracle Payroll Interface (H2PI) for element types |
Implementation/DBA Data: |
APPS.HR_H2PI_ELEMENT_TYPES_V
|
View Text
SELECT ET. LAST_UPDATE_DATE
, ET. ELEMENT_TYPE_ID
, ET.BUSINESS_GROUP_ID
, ET.LEGISLATION_CODE
, ET.ELEMENT_NAME
, ET. PROCESSING_TYPE
, ET. EFFECTIVE_START_DATE
, ET. EFFECTIVE_END_DATE
FROM PAY_ELEMENT_TYPES_F ET
WHERE ET.ATTRIBUTE2 = 'Y'
Columns
Name |
LAST_UPD_DATE |
ELEMENT_TYPE_ID |
BUSINESS_GROUP_ID |
LEGISLATION_CODE |
ELEMENT_NAME |
PROCESSING_TYPE |
EFFECTIVE_START_DATE |
EFFECTIVE_END_DATE |