40: */
41: delete from per_abs_attendance_types_tl t
42: where not exists
43: (select null
44: from per_absence_attendance_types b
45: where b.absence_attendance_type_id = t.absence_attendance_type_id
46: );
47:
48: /*
79: b.creation_date,
80: b.last_updated_by,
81: b.last_update_date,
82: b.last_update_login
83: from per_absence_attendance_types b
84: where not exists (select '1'
85: from per_abs_attendance_types_tl tl
86: where tl.absence_attendance_type_id = b.absence_attendance_type_id
87: and tl.language = l_current_language);