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.

APPS.PER_DE_ELE_API dependencies on PAY_ELEMENT_ENTRIES_F

Line 640: FROM pay_element_entries_f ee

636: --fix for Bug 13343138
637: -- cursor to find the start and end date of the last record
638: CURSOR C_REC_DATE is
639: SELECT ee.effective_start_date
640: FROM pay_element_entries_f ee
641: WHERE ee.element_entry_id = p_element_entry_id
642: and p_effective_date between ee.effective_start_date and ee.effective_end_date;
643:
644: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;

Line 644: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;

640: FROM pay_element_entries_f ee
641: WHERE ee.element_entry_id = p_element_entry_id
642: and p_effective_date between ee.effective_start_date and ee.effective_end_date;
643:
644: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;
645:
646: --fix for Bug 13343138 ends
647:
648: BEGIN