[Home] [Help]
1441: -- I assume there can only be one record for a given pay_plan and user table_id
1442: CURSOR cur_ppw IS
1443: SELECT ppw.to_step
1444: ,ppl.maximum_step
1445: FROM ghr_pay_plan_waiting_periods ppw
1446: ,ghr_pay_plans ppl
1447: WHERE ppl.pay_plan = p_pay_plan
1448: AND ppl.equivalent_pay_plan = ppw.pay_plan
1449: AND ppw.from_step = p_current_step;