DBA Data[Home] [Help]

APPS.GHR_PC_BASIC_PAY dependencies on GHR_PAY_PLAN_WAITING_PERIODS

Line 1462: FROM ghr_pay_plan_waiting_periods ppw

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;