APPS.PER_VIEWS_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 38: pay_element_entries_f pee

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
42: and pee.assignment_id = P_assignment_id

Line 596: pay_element_entries_f pee

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
600: and pee.effective_start_date between d6 and d7 ;

Line 696: pay_element_entries_f pee,

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
700: where ( pap.accrual_plan_id = p_plan_id OR

Line 1047: from pay_element_entries_f

1043: -- if later then first period start. Accrual period start date accordingly.
1044: --
1045: select min(effective_start_date)
1046: into l_plan_start_date
1047: from pay_element_entries_f
1048: where element_entry_id = l_element_entry_id;
1049: ---
1050: --- Set the return params
1051: --