FND Design Data [Home] [Help]

View: PAY_ELEMENT_ENTRY_VALUES_X

Product: PAY - Payroll
Description: Date-effective view.
Implementation/DBA Data: ViewAPPS.PAY_ELEMENT_ENTRY_VALUES_X
View Text

SELECT ELEMENT_ENTRY_VALUE_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, INPUT_VALUE_ID
, ELEMENT_ENTRY_ID
, SCREEN_ENTRY_VALUE
FROM PAY_ELEMENT_ENTRY_VALUES_F
WHERE TRUNC(SYSDATE) BETWEEN EFFECTIVE_START_DATE
AND EFFECTIVE_END_DATE

Columns

Name
ELEMENT_ENTRY_VALUE_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
INPUT_VALUE_ID
ELEMENT_ENTRY_ID
SCREEN_ENTRY_VALUE