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_ES_COMP_CERT_ARCHIVE_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 569: ,pay_element_types_f pet

565: SELECT screen_entry_value ss_id
566: FROM pay_element_entries_f peef
567: ,pay_element_entry_values_f peev
568: ,pay_input_values_f piv
569: ,pay_element_types_f pet
570: WHERE pet.element_name = 'Social Security Details'
571: AND piv.element_type_id = pet.element_type_id
572: AND pet.legislation_code = 'ES'
573: AND piv.name ='Social Security Identifier'

Line 745: ,pay_element_types_f pet

741: ,min(decode(p_type,'S',decode(piv.name, 'Last TD Report Paid', eev.screen_entry_value, null),null)) last_TD_date
742: FROM pay_element_entries_f pee
743: ,pay_element_entry_values_f eev
744: ,pay_input_values_f piv
745: ,pay_element_types_f pet
746: WHERE pee.element_entry_id = eev.element_entry_id
747: AND c_effective_date BETWEEN pee.effective_start_date AND pee.effective_end_date
748: AND eev.input_value_id + 0 = piv.input_value_id
749: AND c_effective_date BETWEEN eev.effective_start_date AND eev.effective_end_date