APPS.GHR_CPDF_STATRPT dependencies on GHR_PAY_PLANS

Line 920: l_equivalent_pay_plan ghr_pay_plans.equivalent_pay_plan%type;

916: IS
917: l_proc varchar2(30) := 'insert_row';
918: -- Bug 4542476
919: l_locality_pay_area ghr_locality_pay_areas_f.locality_pay_area_code%type;
920: l_equivalent_pay_plan ghr_pay_plans.equivalent_pay_plan%type;
921: -- End Bug 4542476
922: BEGIN
923: hr_utility.set_location('Entering:'||l_proc,5);
924: -- Bug#3231946 Added reference to parameters as the function definition is changed

Line 1280: FROM ghr_pay_plans ppl

1276: FUNCTION pp_gs_equivalent (p_pay_plan IN VARCHAR2)
1277: RETURN BOOLEAN IS
1278: CURSOR cur_ppl IS
1279: SELECT 1
1280: FROM ghr_pay_plans ppl
1281: WHERE ppl.pay_plan = p_pay_plan
1282: AND ppl.equivalent_pay_plan = 'GS';
1283: --
1284: BEGIN