APPS.GHR_EHRI_DYNRPT dependencies on GHR_PAY_PLANS

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

1051: raise;
1052: END;
1053: --
1054:
1055: FUNCTION get_equivalent_pay_plan(p_pay_plan IN ghr_pay_plans.pay_plan%TYPE)
1056: RETURN VARCHAR2 IS
1057: l_result ghr_pay_plans.equivalent_pay_plan%TYPE;
1058: BEGIN
1059: --9862674 added NVL

Line 1057: l_result ghr_pay_plans.equivalent_pay_plan%TYPE;

1053: --
1054:
1055: FUNCTION get_equivalent_pay_plan(p_pay_plan IN ghr_pay_plans.pay_plan%TYPE)
1056: RETURN VARCHAR2 IS
1057: l_result ghr_pay_plans.equivalent_pay_plan%TYPE;
1058: BEGIN
1059: --9862674 added NVL
1060: SELECT NVL(equivalent_pay_plan, '@#')
1061: INTO l_result

Line 1062: FROM ghr_pay_plans

1058: BEGIN
1059: --9862674 added NVL
1060: SELECT NVL(equivalent_pay_plan, '@#')
1061: INTO l_result
1062: FROM ghr_pay_plans
1063: WHERE pay_plan = p_pay_plan;
1064: RETURN l_result;
1065: EXCEPTION
1066: WHEN NO_DATA_FOUND THEN

Line 2523: l_equiv_plan ghr_pay_plans.equivalent_pay_plan%type;

2519: l_log_date ghr_process_log.log_date%type;
2520:
2521: -- Bug 5011003
2522: l_locality_pay_area_code ghr_locality_pay_areas_f.locality_pay_area_code%type;
2523: l_equiv_plan ghr_pay_plans.equivalent_pay_plan%type;
2524: -- End Bug 5011003
2525: -- the following cursor can be used for dual purposes
2526: -- can pass the exact eff date or the eff_date-1 to pick the prior details
2527: --