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_GB_CPX_EXTRACT_FUNCTIONS dependencies on PAY_ELEMENT_LINKS_F

Line 206: pay_element_links_f pel,

202: IS
203: SELECT pet.element_type_id, pee.element_entry_id,
204: pee.effective_start_date, pee.effective_end_date
205: FROM pay_element_entries_f pee,
206: pay_element_links_f pel,
207: pay_element_classifications pec,
208: pay_element_types_f pet
209: WHERE pee.assignment_id = c_assignment_id
210: AND pee.entry_type = 'E'

Line 244: pay_element_links_f pel,

240: IS
241: SELECT pet.element_type_id, pee.element_entry_id,
242: pee.effective_start_date, pee.effective_end_date
243: FROM pay_element_entries_f pee,
244: pay_element_links_f pel,
245: pay_element_classifications pec,
246: pay_element_types_f pet
247: WHERE pee.assignment_id = c_assignment_id
248: AND pee.entry_type = 'E'

Line 460: -- ,pay_element_links_f pel

456: -- SELECT pee.element_entry_id
457: -- ,pee.effective_start_date
458: -- ,pee.effective_end_date
459: -- FROM pay_element_entries_f pee
460: -- ,pay_element_links_f pel
461: -- WHERE pee.assignment_id = c_assignment_id
462: -- AND pee.element_link_id = pel.element_link_id
463: -- AND pel.element_type_id = c_element_type_id
464: -- AND pee.effective_start_date =

Line 522: FROM pay_element_entries_f pee, pay_element_links_f pel

518: )
519: IS
520: SELECT pee.element_entry_id, pee.effective_start_date
521: ,pee.effective_end_date
522: FROM pay_element_entries_f pee, pay_element_links_f pel
523: WHERE pee.assignment_id = c_assignment_id
524: AND pee.entry_type = 'E'
525: AND pee.element_link_id = pel.element_link_id
526: AND c_effective_date BETWEEN pee.effective_start_date