DBA Data[Home] [Help]

APPS.PAY_NO_HIGH_RATE_TAX dependencies on PAY_INPUT_VALUES_F

Line 757: pay_input_values_f iv

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
761: AND l_date between ee.effective_start_date and ee.effective_end_date

Line 801: ,pay_input_values_f piv

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
804: WHERE ppa.payroll_action_id = pay_act_id
805: AND pee.assignment_id = p_asg_id