APPS.HXC_RETRIEVE_ABSENCES dependencies on PER_ABS_ATTENDANCE_TYPES_TL

Line 1083: per_abs_attendance_types_tl havtl

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');
1087:

Line 2755: FROM per_abs_attendance_types_tl

2751:
2752: l_name VARCHAR2(500) := 'ERROR';
2753: CURSOR get_name (p_abs_id IN NUMBER)
2754: IS SELECT name
2755: FROM per_abs_attendance_types_tl
2756: WHERE absence_attendance_type_id = p_abs_id
2757: AND language = USERENV('LANG');
2758:
2759:

Line 4332: per_abs_attendance_types_tl pertl

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
4336: AND pertl.language = USERENV('LANG');