DBA Data[Home] [Help]

APPS.PER_VIEWS_PKG dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 37: pay_element_entry_values_f pev,

33: P_plan_id number ) IS
34: select sum(to_number(nvl(pev.SCREEN_ENTRY_VALUE,'0')) *
35: to_number(pnc.add_or_subtract))
36: from pay_net_calculation_rules pnc,
37: pay_element_entry_values_f pev,
38: pay_element_entries_f pee
39: where pnc.accrual_plan_id = p_plan_id
40: and pnc.input_value_id = pev.input_value_id + 0
41: and pev.element_entry_id = pee.element_entry_id

Line 595: from pay_element_entry_values_f pev,

591: P_current_carry_over => n3);
592: --
593: select nvl(sum(to_number(nvl(pev.SCREEN_ENTRY_VALUE,'0'))), 0)
594: into l_accrual
595: from pay_element_entry_values_f pev,
596: pay_element_entries_f pee
597: where pev.input_value_id = p_input_value_id
598: and pev.element_entry_id = pee.element_entry_id
599: and pee.assignment_id = p_assignment_id

Line 695: pay_element_entry_values_f pev,

691: pap.accrual_start,
692: pev.SCREEN_ENTRY_VALUE,
693: pee.element_entry_id
694: from pay_accrual_plans pap,
695: pay_element_entry_values_f pev,
696: pay_element_entries_f pee,
697: pay_element_links_f pel,
698: pay_element_types_f pet,
699: pay_input_values_f piv