APPS.GHR_CPDF_STATRPT dependencies on GHR_PAY_PLANS

Line 950: l_equivalent_pay_plan ghr_pay_plans.equivalent_pay_plan%type;

946: IS
947: l_proc varchar2(30) := 'insert_row';
948: -- Bug 4542476
949: l_locality_pay_area ghr_locality_pay_areas_f.locality_pay_area_code%type;
950: l_equivalent_pay_plan ghr_pay_plans.equivalent_pay_plan%type;
951: -- End Bug 4542476
952: BEGIN
953: hr_utility.set_location('Entering:'||l_proc,5);
954: -- Bug#3231946 Added reference to parameters as the function definition is changed

Line 1315: FROM ghr_pay_plans ppl

1311: FUNCTION pp_gs_equivalent (p_pay_plan IN VARCHAR2)
1312: RETURN BOOLEAN IS
1313: CURSOR cur_ppl IS
1314: SELECT 1
1315: FROM ghr_pay_plans ppl
1316: WHERE ppl.pay_plan = p_pay_plan
1317: AND ppl.equivalent_pay_plan = 'GS';
1318: --
1319: BEGIN