View: PAY_ELEMENT_ENTRIES_V

Product:	PAY - Payroll
Description:	Used to support user interface
Implementation/DBA Data:	APPS.PAY_ELEMENT_ENTRIES_V

View Text

SELECT PETTL.ELEMENT_NAME
, INVTL.NAME
, HR_CHKFMT.CHANGEFORMAT(PEV.SCREEN_ENTRY_VALUE
, INV.UOM
, PET.OUTPUT_CURRENCY_CODE) ENTRY_VALUE
, SCREEN_ENTRY_VALUE
, PEE.ASSIGNMENT_ID
, PEE.CREATOR_ID ASSIGNMENT_ACTION_ID
, INV.EFFECTIVE_START_DATE INV_EFFECTIVE_START_DATE
, INV.EFFECTIVE_END_DATE INV_EFFECTIVE_END_DATE
, INV.DISPLAY_SEQUENCE
, PEV.EFFECTIVE_START_DATE PEV_EFFECTIVE_START_DATE
, PEV.EFFECTIVE_END_DATE PEV_EFFECTIVE_END_DATE
, PEE.EFFECTIVE_START_DATE PEE_EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE PEE_EFFECTIVE_END_DATE
, PEE.ELEMENT_ENTRY_ID
FROM PAY_INPUT_VALUES_F_TL INVTL
, PAY_INPUT_VALUES_F INV
, PAY_ELEMENT_ENTRY_VALUES_F PEV
, PAY_ELEMENT_TYPES_F_TL PETTL
, PAY_ELEMENT_TYPES_F PET
, PAY_ELEMENT_LINKS_F PEL
, PAY_ELEMENT_ENTRIES_F PEE
WHERE PETTL.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND PETTL.LANGUAGE = USERENV('LANG')
AND INVTL.INPUT_VALUE_ID = INV.INPUT_VALUE_ID
AND INVTL.LANGUAGE = USERENV('LANG')
AND INV.INPUT_VALUE_ID = PEV.INPUT_VALUE_ID
AND PEE.EFFECTIVE_START_DATE BETWEEN INV.EFFECTIVE_START_DATE
AND INV.EFFECTIVE_END_DATE
AND PEV.ELEMENT_ENTRY_ID = PEE.ELEMENT_ENTRY_ID
AND PEE.EFFECTIVE_START_DATE BETWEEN PEV.EFFECTIVE_START_DATE
AND PEV.EFFECTIVE_END_DATE
AND PET.ELEMENT_TYPE_ID = PEL.ELEMENT_TYPE_ID
AND PEE.EFFECTIVE_START_DATE BETWEEN PET.EFFECTIVE_START_DATE
AND PET.EFFECTIVE_END_DATE
AND PEL.ELEMENT_LINK_ID = PEE.ELEMENT_LINK_ID
AND PEE.EFFECTIVE_START_DATE BETWEEN PEL.EFFECTIVE_START_DATE
AND PEL.EFFECTIVE_END_DATE
AND PEE.ENTRY_TYPE = 'B'

Columns