DBA Data[Home] [Help]

APPS.PAY_CA_EMP_TAX_INF dependencies on PAY_INPUT_VALUES_F

Line 984: pay_input_values_f piv

980: peev.screen_entry_value
981: )
982: from pay_element_entries_f pee,
983: pay_element_entry_values_f peev,
984: pay_input_values_f piv
985: WHERE l_effective_date
986: between pee.effective_start_date AND pee.effective_end_date
987: AND pee.element_entry_id = peev.element_entry_id
988: AND pee.entry_type = 'E'

Line 1171: pay_input_values_f piv,

1167: l_assignment_id in Number,
1168: l_exemption in VARCHAR2) IS
1169: select nvl(sum(pev.screen_entry_value),0)
1170: from pay_element_types_f pet,
1171: pay_input_values_f piv,
1172: pay_element_entries_f pee,
1173: pay_element_entry_Values_f pev,
1174: pay_payroll_actions ppa,
1175: pay_assignment_actions paa,