DBA Data[Home] [Help]

APPS.PER_ABS_BUS dependencies on PAY_ELEMENT_ENTRIES_F

Line 103: pay_element_entries_f pee,

99: select nvl(fnd_number.canonical_to_number(pev.screen_entry_value), 0), -- bug 7579341, hint removed
100: pev.effective_start_date,
101: pev.effective_end_date
102: from pay_element_entry_values_f pev,
103: pay_element_entries_f pee,
104: per_all_assignments_f paa,
105: per_absence_attendance_types abt
106: where pev.element_entry_id = pee.element_entry_id
107: and pev.input_value_id = abt.input_value_id

Line 2304: from pay_element_entries_f pee,

2300: and abt.absence_category = 'S';
2301:
2302: cursor c_get_accrual_plans (p_assignment_id in number) is
2303: select pap.accrual_plan_id, asg.payroll_id
2304: from pay_element_entries_f pee,
2305: pay_element_links_f pel,
2306: pay_element_types_f pet,
2307: pay_input_values_f piv,
2308: per_all_assignments_f asg,