APPS.GHR_CPDF_DYNRPT dependencies on GHR_PAY_PLANS

Line 764: FUNCTION get_equivalent_pay_plan(p_pay_plan IN ghr_pay_plans.pay_plan%TYPE)

760: raise;
761: END;
762: --
763:
764: FUNCTION get_equivalent_pay_plan(p_pay_plan IN ghr_pay_plans.pay_plan%TYPE)
765: RETURN VARCHAR2 IS
766: l_result ghr_pay_plans.equivalent_pay_plan%TYPE;
767: BEGIN
768: --9862674 added NVL

Line 766: l_result ghr_pay_plans.equivalent_pay_plan%TYPE;

762: --
763:
764: FUNCTION get_equivalent_pay_plan(p_pay_plan IN ghr_pay_plans.pay_plan%TYPE)
765: RETURN VARCHAR2 IS
766: l_result ghr_pay_plans.equivalent_pay_plan%TYPE;
767: BEGIN
768: --9862674 added NVL
769: SELECT NVL(equivalent_pay_plan, '@#')
770: INTO l_result

Line 771: FROM ghr_pay_plans

767: BEGIN
768: --9862674 added NVL
769: SELECT NVL(equivalent_pay_plan, '@#')
770: INTO l_result
771: FROM ghr_pay_plans
772: WHERE pay_plan = p_pay_plan;
773: RETURN l_result;
774: EXCEPTION
775: WHEN NO_DATA_FOUND THEN

Line 1261: l_equiv_plan ghr_pay_plans.equivalent_pay_plan%type;

1257: l_log_date ghr_process_log.log_date%type;
1258:
1259: -- Bug 4542476
1260: l_locality_pay_area_code ghr_locality_pay_areas_f.locality_pay_area_code%type;
1261: l_equiv_plan ghr_pay_plans.equivalent_pay_plan%type;
1262: -- End Bug 4542476
1263:
1264:
1265: CURSOR cur_per_details(p_person_id per_all_people_f.person_id%type)