DBA Data[Home] [Help]

APPS.PAY_NO_ABSENCE_USER dependencies on HR_LOOKUPS

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

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

Line 169: FROM HR_LOOKUPS

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