DBA Data[Home] [Help]

APPS.PER_ABSENCE_ATTENDANCES_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 2284: pay_element_entries_f e,

2280: a.payroll_id,
2281: t.start_date,
2282: t.end_date
2283: from per_time_periods t,
2284: pay_element_entries_f e,
2285: per_assignments_f a
2286: where a.person_id = p_per_id
2287: and a.primary_flag = 'Y'
2288: and p_sdstart between a.effective_start_date and a.effective_end_date

Line 2568: pay_element_entries_f pee,

2564: -- Bug 563202 - drive from abs and go via link input value
2565: select nvl(sum(fnd_number.canonical_to_number(
2566: nvl(pev.screen_entry_value,'0.0'))),0)
2567: from pay_element_entry_values_f pev,
2568: pay_element_entries_f pee,
2569: pay_link_input_values_f lnk,
2570: per_absence_attendance_types abs
2571: where abs.absence_attendance_type_id = p_abs_type_id
2572: and lnk.input_value_id = abs.input_value_id

Line 2625: pay_element_entries_f pee,

2621: pap.accrual_units_of_measure,
2622: asg.payroll_id,
2623: asg.business_group_id
2624: from pay_element_entry_values_f pev,
2625: pay_element_entries_f pee,
2626: pay_input_values_f piv,
2627: pay_accrual_plans pap,
2628: per_absence_attendance_types abst,
2629: per_all_assignments_f asg