VIEW: APPS.PAY_JP_SOE_RETRO_E_VALUES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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