[Home] [Help]
View: PAY_JP_SOE_RETRO_E_VALUES_V
View Text
SELECT PEEV.ELEMENT_ENTRY_VALUE_ID
, PEEV.ELEMENT_ENTRY_ID
, PEEV.EFFECTIVE_START_DATE
, PEEV.EFFECTIVE_END_DATE
, PIV.DISPLAY_SEQUENCE
, PIV.UOM
, PIVTL.NAME
, PEEV.SCREEN_ENTRY_VALUE
, SUBSTRB(DECODE( PIV.LOOKUP_TYPE
, NULL
, DECODE( PIV.UOM
, 'M'
, TO_CHAR(TO_NUMBER(PEEV.SCREEN_ENTRY_VALUE)
, FND_CURRENCY.GET_FORMAT_MASK(PET.INPUT_CURRENCY_CODE
, 60))
, HR_CHKFMT.CHANGEFORMAT(PEEV.SCREEN_ENTRY_VALUE
, PIV.UOM
, NULL))
, HR_GENERAL.DECODE_LOOKUP(PIV.LOOKUP_TYPE
, PEEV.SCREEN_ENTRY_VALUE))
, 1
, 80)
FROM PAY_ELEMENT_TYPES_F PET
, PAY_INPUT_VALUES_F_TL PIVTL
, PAY_INPUT_VALUES_F PIV
, PAY_ELEMENT_ENTRY_VALUES_F PEEV
WHERE PIV.INPUT_VALUE_ID=PEEV.INPUT_VALUE_ID
AND PEEV.EFFECTIVE_START_DATE BETWEEN PIV.EFFECTIVE_START_DATE
AND PIV.EFFECTIVE_END_DATE
AND PIVTL.INPUT_VALUE_ID=PIV.INPUT_VALUE_ID
AND PIVTL.LANGUAGE=USERENV('LANG')
AND PET.ELEMENT_TYPE_ID=PIV.ELEMENT_TYPE_ID
AND PEEV.EFFECTIVE_START_DATE BETWEEN PET.EFFECTIVE_START_DATE
AND PET.EFFECTIVE_END_DATE
Columns
Name |
ELEMENT_ENTRY_VALUE_ID |
ELEMENT_ENTRY_ID |
EFFECTIVE_START_DATE |
EFFECTIVE_END_DATE |
DISPLAY_SEQUENCE |
UOM |
NAME |
SCREEN_ENTRY_VALUE |
D_SCREEN_ENTRY_VALUE |