VIEW: APPS.PAY_ELEMENT_ENTRIES_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'