APPS.GHR_CPDF_DYNRPT dependencies on GHR_PAY_PLANS

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

714: raise;
715: END;
716: --
717:
718: FUNCTION get_equivalent_pay_plan(p_pay_plan IN ghr_pay_plans.pay_plan%TYPE)
719: RETURN VARCHAR2 IS
720: l_result ghr_pay_plans.equivalent_pay_plan%TYPE;
721: BEGIN
722: SELECT equivalent_pay_plan

Line 720: l_result ghr_pay_plans.equivalent_pay_plan%TYPE;

716: --
717:
718: FUNCTION get_equivalent_pay_plan(p_pay_plan IN ghr_pay_plans.pay_plan%TYPE)
719: RETURN VARCHAR2 IS
720: l_result ghr_pay_plans.equivalent_pay_plan%TYPE;
721: BEGIN
722: SELECT equivalent_pay_plan
723: INTO l_result
724: FROM ghr_pay_plans

Line 724: FROM ghr_pay_plans

720: l_result ghr_pay_plans.equivalent_pay_plan%TYPE;
721: BEGIN
722: SELECT equivalent_pay_plan
723: INTO l_result
724: FROM ghr_pay_plans
725: WHERE pay_plan = p_pay_plan;
726: RETURN l_result;
727: EXCEPTION
728: WHEN NO_DATA_FOUND THEN

Line 1196: l_equiv_plan ghr_pay_plans.equivalent_pay_plan%type;

1192: l_log_date ghr_process_log.log_date%type;
1193:
1194: -- Bug 4542476
1195: l_locality_pay_area_code ghr_locality_pay_areas_f.locality_pay_area_code%type;
1196: l_equiv_plan ghr_pay_plans.equivalent_pay_plan%type;
1197: -- End Bug 4542476
1198:
1199:
1200: CURSOR cur_per_details(p_person_id per_all_people_f.person_id%type)