32: CURSOR cur_end_date ( p_pactid NUMBER
33: , p_date DATE
34: ) IS
35: SELECT TP.end_date + 1 36: FROM per_time_periods TP 37: , pay_payroll_actions PACT
38: WHERE PACT.payroll_action_id = p_pactid
39: AND PACT.payroll_id = TP.payroll_id
40: AND p_date BETWEEN TP.start_date AND TP.end_date;