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.PAY_NO_HIGH_RATE_TAX dependencies on PAY_ELEMENT_TYPES_F

Line 734: pay_element_types_f et,

730: CURSOR get_tax_card_details( l_assignment_id number,l_date date , l_input_name varchar2) is
731: SELECT screen_entry_value
732: FROM pay_element_entry_values_f eev,
733: pay_element_entries_f ee,
734: pay_element_types_f et,
735: pay_input_values_f iv
736: WHERE eev.element_entry_id = ee.element_entry_id
737: And l_date between eev.effective_start_date and ee.effective_end_date
738: And ee.assignment_id = l_assignment_id

Line 761: pay_element_types_f et

757: -- cursor to check if element TAX CARD exists on the primary assignment of the employee
758: CURSOR csr_chk_tax_card( l_assignment_id number,l_date date ) is
759: SELECT ee.ELEMENT_ENTRY_ID
760: FROM pay_element_entries_f ee,
761: pay_element_types_f et
762: WHERE et.element_name = 'Tax Card'
763: And et.legislation_code = 'NO'
764: And l_date between et.effective_start_date and et.effective_end_date
765: And et.element_type_id = ee.element_type_id

Line 780: ,pay_element_types_f pet

776: SELECT distinct eev.screen_entry_value Tax_Municipality
777: FROM pay_element_entries_f pee
778: ,pay_element_entry_values_f eev
779: ,pay_input_values_f piv
780: ,pay_element_types_f pet
781: ,pay_payroll_actions ppa
782: WHERE ppa.payroll_action_id = pay_act_id
783: AND pee.assignment_id = p_asg_id
784: AND pet.element_name = 'Employer Contribution Information'