DBA Data[Home] [Help]

APPS.PAY_US_PTO_ACCRUAL dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 165: pay_element_entry_values_f pev,

161: P_plan_id number ) IS
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