23: --
24: CURSOR get_period_dates IS
25: SELECT ptp.start_date start_date
26: ,ptp.end_date end_date
27: FROM per_time_periods ptp
28: WHERE ptp.payroll_id=p_payroll_id
29: AND p_date_earned BETWEEN ptp.start_date AND ptp.end_date;
30: --
31: -- Cursor get_db
91: --
92: CURSOR get_period_dates IS
93: SELECT ptp.start_date start_date
94: ,ptp.end_date end_date
95: FROM per_time_periods ptp
96: WHERE ptp.payroll_id=p_payroll_id
97: AND p_date_earned BETWEEN ptp.start_date AND ptp.end_date;
98: --
99: -- Cursor get_db