DBA Data[Home] [Help]

APPS.PER_ABSENCE_ATTENDANCES_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 2180: pay_element_entries_f e,

2176: a.payroll_id,
2177: t.start_date,
2178: t.end_date
2179: from per_time_periods t,
2180: pay_element_entries_f e,
2181: per_assignments_f a
2182: where a.person_id = p_per_id
2183: and a.primary_flag = 'Y'
2184: and p_sdstart between a.effective_start_date and a.effective_end_date

Line 2464: pay_element_entries_f pee,

2460: -- Bug 563202 - drive from abs and go via link input value
2461: select nvl(sum(fnd_number.canonical_to_number(
2462: nvl(pev.screen_entry_value,'0.0'))),0)
2463: from pay_element_entry_values_f pev,
2464: pay_element_entries_f pee,
2465: pay_link_input_values_f lnk,
2466: per_absence_attendance_types abs
2467: where abs.absence_attendance_type_id = p_abs_type_id
2468: and lnk.input_value_id = abs.input_value_id

Line 2521: pay_element_entries_f pee,

2517: pap.accrual_units_of_measure,
2518: asg.payroll_id,
2519: asg.business_group_id
2520: from pay_element_entry_values_f pev,
2521: pay_element_entries_f pee,
2522: pay_input_values_f piv,
2523: pay_accrual_plans pap,
2524: per_absence_attendance_types abst,
2525: per_all_assignments_f asg