DBA Data[Home] [Help]

APPS.PAY_IE_PRSI dependencies on PER_TIME_PERIODS

Line 271: from per_time_periods ptp

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

Line 290: from per_time_periods ptp

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