330: END IF;
331:
332: SELECT MEANING
333: INTO l_rate 334: FROM HR_LOOKUPS 335: WHERE lookup_type = 'AU_MLS_RATES'
336: AND lookup_code = l_code
337: AND enabled_flag = 'Y'
338: AND p_date between START_DATE_ACTIVE AND NVL(END_DATE_ACTIVE,to_date('31-12-4712','DD-MM-YYYY'));