View: GHR_ELEMENT_ENTRY_VALUES_H_V

Product:	GHR - US Federal Human Resources
Description:	Mapping of GHR_PA_HISTORY columns to PAY_ELEMENT_ENTRY_VALUES_F.
Implementation/DBA Data:	APPS.GHR_ELEMENT_ENTRY_VALUES_H_V

View Text

SELECT PA_HISTORY_ID
, PROCESS_DATE
, EFFECTIVE_DATE
, DML_OPERATION
, PRE_VALUES_FLAG
, ALTERED_PA_REQUEST_ID
, PA_REQUEST_ID
, NATURE_OF_ACTION_ID
, GHR_GENERAL.RETURN_NUMBER(INFORMATION1) ELEMENT_ENTRY_VALUE_ID
, FND_DATE.CANONICAL_TO_DATE(INFORMATION2) EFFECTIVE_START_DATE
, FND_DATE.CANONICAL_TO_DATE(INFORMATION3) EFFECTIVE_END_DATE
, GHR_GENERAL.RETURN_NUMBER(INFORMATION4) INPUT_VALUE_ID
, GHR_GENERAL.RETURN_NUMBER(INFORMATION5) ELEMENT_ENTRY_ID
, SUBSTR(INFORMATION6
, 1
, 60) SCREEN_ENTRY_VALUE
FROM GHR_PA_HISTORY
WHERE TABLE_NAME = 'PAY_ELEMENT_ENTRY_VALUES_F'

Columns