eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.BEN_EXT_PERSON dependencies on HR_LOOKUPS

Line 2194: , hr_lookups luk

2190: SELECT abt.absence_category
2191: , abt.name abs_type
2192: , luk.meaning abs_category
2193: FROM per_absence_attendance_types abt
2194: , hr_lookups luk
2195: WHERE abt.absence_attendance_type_id = p_absence_attendance_type_id
2196: AND abt.absence_category = luk.lookup_code
2197: AND luk.lookup_type = 'ABSENCE_CATEGORY';
2198:

Line 2205: , hr_lookups lkp

2201: CURSOR abs_reason(p_abs_attendance_reason_id NUMBER) IS
2202: SELECT lkp.meaning abs_reason ,
2203: abr.name -- Bug 2841958, getting the reason code
2204: FROM per_abs_attendance_reasons abr
2205: , hr_lookups lkp
2206: WHERE abr.abs_attendance_reason_id = p_abs_attendance_reason_id
2207: AND abr.name = lkp.lookup_code
2208: AND lkp.lookup_type = 'ABSENCE_REASON';
2209:

Line 3080: from hr_lookups

3076:
3077: cursor c_hr_lkup(p_lkup_type varchar2,
3078: p_lkup_code varchar2) is
3079: select meaning
3080: from hr_lookups
3081: where lookup_type = p_lkup_type
3082: and lookup_code = p_lkup_code
3083: ;
3084: