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 756: pay_element_types_f et,

752: CURSOR get_tax_card_details( l_assignment_id number,l_date date , l_input_name varchar2) is
753: SELECT screen_entry_value
754: FROM pay_element_entry_values_f eev,
755: pay_element_entries_f ee,
756: pay_element_types_f et,
757: pay_input_values_f iv
758: WHERE eev.element_entry_id = ee.element_entry_id
759: And l_date between eev.effective_start_date and eev.effective_end_date
760: And ee.assignment_id = l_assignment_id

Line 783: pay_element_types_f et

779: -- cursor to check if element TAX CARD exists on the primary assignment of the employee
780: CURSOR csr_chk_tax_card( l_assignment_id number,l_date date ) is
781: SELECT ee.ELEMENT_ENTRY_ID
782: FROM pay_element_entries_f ee,
783: pay_element_types_f et
784: WHERE et.element_name = 'Tax Card'
785: And et.legislation_code = 'NO'
786: And l_date between et.effective_start_date and et.effective_end_date
787: And et.element_type_id = ee.element_type_id

Line 802: ,pay_element_types_f pet

798: SELECT distinct eev.screen_entry_value Tax_Municipality
799: FROM pay_element_entries_f pee
800: ,pay_element_entry_values_f eev
801: ,pay_input_values_f piv
802: ,pay_element_types_f pet
803: ,pay_payroll_actions ppa
804: WHERE ppa.payroll_action_id = pay_act_id
805: AND pee.assignment_id = p_asg_id
806: AND pet.element_name = 'Employer Contribution Information'