DBA Data[Home] [Help]

APPS.PAY_IE_PRSI dependencies on PER_TIME_PERIODS

Line 212: from per_time_periods ptp

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

Line 231: from per_time_periods ptp

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