APPS.GHR_EHRI_DYNRPT dependencies on GHR_PAY_PLANS

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

1006: raise;
1007: END;
1008: --
1009:
1010: FUNCTION get_equivalent_pay_plan(p_pay_plan IN ghr_pay_plans.pay_plan%TYPE)
1011: RETURN VARCHAR2 IS
1012: l_result ghr_pay_plans.equivalent_pay_plan%TYPE;
1013: BEGIN
1014: SELECT equivalent_pay_plan

Line 1012: l_result ghr_pay_plans.equivalent_pay_plan%TYPE;

1008: --
1009:
1010: FUNCTION get_equivalent_pay_plan(p_pay_plan IN ghr_pay_plans.pay_plan%TYPE)
1011: RETURN VARCHAR2 IS
1012: l_result ghr_pay_plans.equivalent_pay_plan%TYPE;
1013: BEGIN
1014: SELECT equivalent_pay_plan
1015: INTO l_result
1016: FROM ghr_pay_plans

Line 1016: FROM ghr_pay_plans

1012: l_result ghr_pay_plans.equivalent_pay_plan%TYPE;
1013: BEGIN
1014: SELECT equivalent_pay_plan
1015: INTO l_result
1016: FROM ghr_pay_plans
1017: WHERE pay_plan = p_pay_plan;
1018: RETURN l_result;
1019: EXCEPTION
1020: WHEN NO_DATA_FOUND THEN

Line 2369: l_equiv_plan ghr_pay_plans.equivalent_pay_plan%type;

2365: l_log_date ghr_process_log.log_date%type;
2366:
2367: -- Bug 5011003
2368: l_locality_pay_area_code ghr_locality_pay_areas_f.locality_pay_area_code%type;
2369: l_equiv_plan ghr_pay_plans.equivalent_pay_plan%type;
2370: -- End Bug 5011003
2371: -- the following cursor can be used for dual purposes
2372: -- can pass the exact eff date or the eff_date-1 to pick the prior details
2373: --