208: l_period_start_date date;
209: --
210: cursor get_start_date is
211: select ptp.start_date
212: from per_time_periods ptp
213: where ptp.payroll_id = p_payroll_id
214: and p_session_date between ptp.start_date and ptp.end_date;
215: --
216: Begin
227: l_period_end_date date;
228: --
229: cursor get_end_date is
230: select ptp.end_date
231: from per_time_periods ptp
232: where ptp.payroll_id = p_payroll_id
233: and p_session_date between ptp.start_date and ptp.end_date;
234: --
235: Begin