267: l_period_start_date date;
268: --
269: cursor get_start_date is
270: select ptp.start_date
271: from per_time_periods ptp
272: where ptp.payroll_id = p_payroll_id
273: and p_session_date between ptp.start_date and ptp.end_date;
274: --
275: Begin
286: l_period_end_date date;
287: --
288: cursor get_end_date is
289: select ptp.end_date
290: from per_time_periods ptp
291: where ptp.payroll_id = p_payroll_id
292: and p_session_date between ptp.start_date and ptp.end_date;
293: --
294: Begin