46: IS
47: l_amount number;
48: BEGIN
49: SELECT global_value INTO l_amount 50: FROM ff_globals_f g 51: WHERE g.global_name = 'IE_PENSIONS_EARNINGS_CAP'
52: AND p_date_earned BETWEEN g.effective_start_date AND g.effective_end_date;
53: RETURN l_amount;
54: END GET_EARNINGS_CAP;