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_LINKS_F

Line 191: ,pay_element_links_f pel

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
195: AND pev.effective_end_date

Line 661: ,pay_element_links_f pel

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
665: AND pev.effective_end_date

Line 3230: ,pay_element_links_f pel

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
3234: AND pel.effective_end_date

Line 4969: ,pay_element_links_f pel

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
4973: pee.effective_end_date BETWEEN c_start_date