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