65: per_absence_attendance_types paat,
66: per_abs_attendance_types_tl paatt,
67: pay_element_types_f petf,
68: pay_element_types_f_tl petft,
69: hr_lookups ntl, -- NAME_TRANSLATIONS
70: hr_lookups acl -- ABSENCE_CATEGORY
71: WHERE hae.absence_attendance_type_id = paat.absence_attendance_type_id
72: AND hae.element_type_id = petf.element_type_id
73: AND ntl.lookup_type = 'NAME_TRANSLATIONS'
66: per_abs_attendance_types_tl paatt,
67: pay_element_types_f petf,
68: pay_element_types_f_tl petft,
69: hr_lookups ntl, -- NAME_TRANSLATIONS
70: hr_lookups acl -- ABSENCE_CATEGORY
71: WHERE hae.absence_attendance_type_id = paat.absence_attendance_type_id
72: AND hae.element_type_id = petf.element_type_id
73: AND ntl.lookup_type = 'NAME_TRANSLATIONS'
74: AND ntl.lookup_code = hae.uom