[Home] [Help]
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
Name |
LAST_UPD_DATE |
BUSINESS_GROUP_ID |
ELEMENT_TYPE_ID |
EFFECTIVE_START_DATE |
EFFECTIVE_END_DATE |
INPUT_VALUE_ID |
NAME |
LEGISLATION_CODE |
UOM |
MANDATORY_FLAG |
DEFAULT_VALUE |
LOOKUP_TYPE |