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 755: pay_element_entries_f ee,

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

Line 782: FROM pay_element_entries_f ee,

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

Line 799: FROM pay_element_entries_f pee

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