DBA Data[Home] [Help]

APPS.BEN_EXT_PERSON dependencies on HR_LOOKUPS

Line 2228: , hr_lookups luk

2224: SELECT abt.absence_category
2225: , abt.name abs_type
2226: , luk.meaning abs_category
2227: FROM per_absence_attendance_types abt
2228: , hr_lookups luk
2229: WHERE abt.absence_attendance_type_id = p_absence_attendance_type_id
2230: AND abt.absence_category = luk.lookup_code
2231: AND luk.lookup_type = 'ABSENCE_CATEGORY';
2232:

Line 2239: , hr_lookups lkp

2235: CURSOR abs_reason(p_abs_attendance_reason_id NUMBER) IS
2236: SELECT lkp.meaning abs_reason ,
2237: abr.name -- Bug 2841958, getting the reason code
2238: FROM per_abs_attendance_reasons abr
2239: , hr_lookups lkp
2240: WHERE abr.abs_attendance_reason_id = p_abs_attendance_reason_id
2241: AND abr.name = lkp.lookup_code
2242: AND lkp.lookup_type = 'ABSENCE_REASON';
2243:

Line 3114: from hr_lookups

3110:
3111: cursor c_hr_lkup(p_lkup_type varchar2,
3112: p_lkup_code varchar2) is
3113: select meaning
3114: from hr_lookups
3115: where lookup_type = p_lkup_type
3116: and lookup_code = p_lkup_code
3117: ;
3118: