APPS.GHR_PC_BASIC_PAY dependencies on GHR_PAY_PLANS

Line 1446: ,ghr_pay_plans ppl

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

Line 1827: select 1 from ghr_pay_plans

1823: l_proc VARCHAR2(20) := 'get_basic_pay';
1824:
1825: --1360547 Fix start
1826: cursor cfws is
1827: select 1 from ghr_pay_plans
1828: where EQUIVALENT_PAY_PLAN = 'FW'
1829: and PAY_PLAN = l_pay_plan;
1830:
1831: --5470182

Line 1833: select 1 from ghr_pay_plans

1829: and PAY_PLAN = l_pay_plan;
1830:
1831: --5470182
1832: cursor ces is
1833: select 1 from ghr_pay_plans
1834: where EQUIVALENT_PAY_PLAN = 'ES'
1835: and PAY_PLAN = l_pay_plan;
1836:
1837: l_fws_flag VARCHAR2(5);