224: CURSOR get_dates IS
225: SELECT ptp.start_date
226: , ptp.end_date
227: , ptp.regular_payment_date
228: FROM pay_all_payrolls_f papf
229: , per_time_periods ptp
230: WHERE papf.payroll_id = p_payroll_id
231: AND trunc(p_run_date)
232: BETWEEN papf.effective_start_date
550: CURSOR get_dates IS
551: SELECT ptp.start_date
552: , ptp.end_date
553: , ptp.regular_payment_date
554: FROM pay_all_payrolls_f papf
555: , per_time_periods ptp
556: , per_all_assignments_f paf
557: WHERE papf.payroll_id = paf.payroll_id
558: AND paf.assignment_id = p_assignment_id