APPS.HXC_RETRIEVE_ABSENCES dependencies on PER_ABSENCE_ATTENDANCE_TYPES

Line 1082: FROM per_absence_attendance_types hav,

1078:
1079: CURSOR get_alias_value ( p_alias_id IN NUMBER,
1080: p_element_id IN NUMBER )
1081: IS SELECT havtl.name
1082: FROM per_absence_attendance_types hav,
1083: per_abs_attendance_types_tl havtl
1084: WHERE hav.absence_attendance_type_id = havtl.absence_attendance_type_id
1085: AND hav.absence_attendance_type_id = p_element_id
1086: AND language = userenv('LANG');

Line 4331: per_absence_attendance_types per,

4327: l_inc_dec,
4328: l_name,
4329: l_uom
4330: FROM hxc_absence_type_elements hxc,
4331: per_absence_attendance_types per,
4332: per_abs_attendance_types_tl pertl
4333: WHERE hxc.element_type_id = p_element_type_id
4334: AND hxc.absence_attendance_type_id = per.absence_attendance_type_id
4335: AND per.absence_attendance_type_id = pertl.absence_attendance_type_id