DBA Data[Home] [Help]

APPS.PAY_NO_ABSENCE_USER dependencies on HR_LOOKUPS

Line 169: -- Version 115.1 , Changed query to get value from hr_lookups

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;

Line 170: FROM HR_LOOKUPS

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