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.PQP_US_PENSION_EXTRACTS dependencies on PAY_ELEMENT_ENTRIES_F

Line 190: ,pay_element_entries_f pee

186: ,c_input_value_id IN NUMBER) IS
187: SELECT pev.screen_entry_value
188: FROM pay_input_values_f piv
189: ,pay_element_entry_values_f pev
190: ,pay_element_entries_f pee
191: ,pay_element_links_f pel
192: WHERE c_effective_date BETWEEN piv.effective_start_date
193: AND piv.effective_end_date
194: AND c_effective_date BETWEEN pev.effective_start_date

Line 660: ,pay_element_entries_f pee

656: SELECT pev.screen_entry_value
657: ,pee.effective_start_date
658: FROM pay_input_values_f piv
659: ,pay_element_entry_values_f pev
660: ,pay_element_entries_f pee
661: ,pay_element_links_f pel
662: WHERE c_effective_date BETWEEN piv.effective_start_date
663: AND piv.effective_end_date
664: AND c_effective_date BETWEEN pev.effective_start_date

Line 3229: FROM pay_element_entries_f pee

3225: CURSOR csr_chk_entry (c_effective_date IN DATE
3226: ,c_element_type_id IN NUMBER
3227: ,c_assignment_id IN NUMBER) IS
3228: SELECT 'X'
3229: FROM pay_element_entries_f pee
3230: ,pay_element_links_f pel
3231: WHERE c_effective_date BETWEEN pee.effective_start_date
3232: AND pee.effective_end_date
3233: AND c_effective_date BETWEEN pel.effective_start_date

Line 4968: FROM pay_element_entries_f pee

4964: ,c_payroll_id IN NUMBER
4965: ,c_business_group_id IN NUMBER
4966: ,c_gre_id IN NUMBER) IS
4967: SELECT 'X'
4968: FROM pay_element_entries_f pee
4969: ,pay_element_links_f pel
4970: WHERE (c_end_date BETWEEN pee.effective_start_date
4971: AND pee.effective_end_date
4972: OR