165: BEGIN
166: SELECT MEANING
167: INTO l_abs_cat_meaning
168: --FROM FND_LOOKUP_VALUES
169: -- Version 115.1 , Changed query to get value from hr_lookups
170: FROM HR_LOOKUPS
171: WHERE LOOKUP_TYPE = 'ABSENCE_CATEGORY'
172: AND ENABLED_FLAG = 'Y'
173: AND LOOKUP_CODE = p_absence_category;
166: SELECT MEANING
167: INTO l_abs_cat_meaning
168: --FROM FND_LOOKUP_VALUES
169: -- Version 115.1 , Changed query to get value from hr_lookups
170: FROM HR_LOOKUPS
171: WHERE LOOKUP_TYPE = 'ABSENCE_CATEGORY'
172: AND ENABLED_FLAG = 'Y'
173: AND LOOKUP_CODE = p_absence_category;
174: EXCEPTION