DBA Data[Home] [Help]

APPS.PAY_CA_EMP_TAX_INF dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 983: pay_element_entry_values_f peev,

979: peev.screen_entry_value|| '.00',
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

Line 1173: pay_element_entry_Values_f pev,

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,
1176: pay_payroll_actions ppa2
1177: where pee.assignment_id = l_assignment_id