DBA Data[Home] [Help]

APPS.PAY_SE_ABSENCE_USER dependencies on HR_LOOKUPS

Line 122: FROM hr_lookups

118: -- To select absence category meaning by passing code
119: BEGIN
120: SELECT MEANING
121: INTO l_abs_cat_meaning
122: FROM hr_lookups
123: WHERE LOOKUP_TYPE = 'ABSENCE_CATEGORY'
124: AND ENABLED_FLAG = 'Y'
125: AND LOOKUP_CODE = p_absence_category;
126: EXCEPTION

Line 333: FROM HR_LOOKUPS

329:
330: row_get_absence CSR_GET_ABSENCE%ROWTYPE;
331:
332: CURSOR CSR_GET_ABCAT is SELECT MEANING
333: FROM HR_LOOKUPS
334: WHERE LOOKUP_TYPE = 'ABSENCE_CATEGORY'
335: AND ENABLED_FLAG = 'Y'
336: AND LOOKUP_CODE = p_absence_category;
337: