APPS.PER_ABSENCE_ATTENDANCES_PKG dependencies on PER_TIME_PERIODS
Line 2283: from per_time_periods t,
2279: e.element_link_id,
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'
Line 2497: from per_time_periods
2493: cursor c18 is
2494: select start_date,
2495: end_date,
2496: 'X' 2497: from per_time_periods 2498: where payroll_id = p_cpay_id
2499: and p_dstart between start_date and end_date;
2500: --
2501: begin