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_ENTRIES_F

Line 733: pay_element_entries_f ee,

729:
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

Line 760: FROM pay_element_entries_f ee,

756:
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

Line 777: FROM pay_element_entries_f pee

773: -- Legislative changes 2007 : cursor to get the tax municipality for Ambulatory operations
774:
775: CURSOR csr_get_amb_op_tax_mun (p_asg_id NUMBER , pay_act_id NUMBER ) IS
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