DBA Data[Home] [Help]

APPS.PAY_NO_HIGH_RATE_TAX dependencies on PAY_INPUT_VALUES_F

Line 735: pay_input_values_f iv

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

Line 779: ,pay_input_values_f piv

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