[Home] [Help]
1458: -- I assume there can only be one record for a given pay_plan and user table_id
1459: CURSOR cur_ppw IS
1460: SELECT ppw.to_step
1461: ,ppl.maximum_step
1462: FROM ghr_pay_plan_waiting_periods ppw
1463: ,ghr_pay_plans ppl
1464: WHERE ppl.pay_plan = p_pay_plan
1465: AND ppl.equivalent_pay_plan = ppw.pay_plan
1466: AND ppw.from_step = p_current_step;