DBA Data[Home] [Help]

APPS.HXC_ABSENCE_TYPE_ALIAS dependencies on PER_ABSENCE_ATTENDANCE_TYPES

Line 65: per_absence_attendance_types paat,

61: paatt.name || ' (' || ntl.meaning || ')',
62: acl.lookup_code absence_category,
63: acl.meaning absence_category_meaning
64: FROM hxc_absence_type_elements hae,
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

Line 147: per_absence_attendance_types paat,

143: DELETE hxc_absence_type_elements_temp haet
144: WHERE haet.element_type_id NOT IN
145: (SELECT pivf.element_type_id
146: FROM per_abs_attendance_types_tl paatt,
147: per_absence_attendance_types paat,
148: pay_input_values_f pivf
149: WHERE paatt.absence_attendance_type_id = paat.absence_attendance_type_id
150: AND paat.absence_attendance_type_id = l_tc_abs_absence_type_id
151: AND paat.input_value_id = pivf.input_value_id