APPS.GHR_PC_BASIC_PAY dependencies on GHR_PAY_PLANS

Line 1463: ,ghr_pay_plans ppl

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;
1467: --

Line 1844: select 1 from ghr_pay_plans

1840: l_proc VARCHAR2(20) := 'get_basic_pay';
1841:
1842: --1360547 Fix start
1843: cursor cfws is
1844: select 1 from ghr_pay_plans
1845: where EQUIVALENT_PAY_PLAN = 'FW'
1846: and PAY_PLAN = l_pay_plan;
1847:
1848: --5470182

Line 1850: select 1 from ghr_pay_plans

1846: and PAY_PLAN = l_pay_plan;
1847:
1848: --5470182
1849: cursor ces is
1850: select 1 from ghr_pay_plans
1851: where EQUIVALENT_PAY_PLAN = 'ES'
1852: and PAY_PLAN = l_pay_plan;
1853:
1854: --- Added for 5871233