eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PAY_BALANCE_ADJUSTMENTS_V

Source

View Text - Preformatted


SELECT pettl.element_name ,pee.creator_id assignment_action_id ,pee.assignment_id ,pee.element_entry_id from pay_element_entries_f pee ,pay_element_links_f pel ,pay_element_types_f_tl pettl where pee.entry_type = 'B' 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 pettl.element_type_id = pel.element_type_id and pettl.language = userenv('LANG')

View Text - HTML Formatted

SELECT PETTL.ELEMENT_NAME
, PEE.CREATOR_ID ASSIGNMENT_ACTION_ID
, PEE.ASSIGNMENT_ID
, PEE.ELEMENT_ENTRY_ID
FROM PAY_ELEMENT_ENTRIES_F PEE
, PAY_ELEMENT_LINKS_F PEL
, PAY_ELEMENT_TYPES_F_TL PETTL
WHERE PEE.ENTRY_TYPE = 'B'
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 PETTL.ELEMENT_TYPE_ID = PEL.ELEMENT_TYPE_ID
AND PETTL.LANGUAGE = USERENV('LANG')