DBA Data[Home] [Help]

APPS.PAY_US_PTO_ACCRUAL dependencies on PAY_ELEMENT_ENTRIES_F

Line 166: pay_element_entries_f pee

162: select sum(to_number(nvl(pev.SCREEN_ENTRY_VALUE,'0')) *
163: to_number(pnc.add_or_subtract))
164: from pay_net_calculation_rules pnc,
165: pay_element_entry_values_f pev,
166: pay_element_entries_f pee
167: where pnc.accrual_plan_id = p_plan_id
168: and pnc.input_value_id = pev.input_value_id + 0
169: and pev.element_entry_id = pee.element_entry_id
170: and pee.assignment_id = P_assignment_id