APPS.PER_ABT_MIGRATION dependencies on PER_ABS_ATTENDANCE_TYPES_TL

Line 41: delete from per_abs_attendance_types_tl t

37: /*
38: ** Clear out any existing data for this range of records
39: **
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

Line 64: insert into per_abs_attendance_types_tl(

60:
61: /*
62: ** Insert the TL rows.
63: */
64: insert into per_abs_attendance_types_tl(
65: absence_attendance_type_id,
66: language,
67: source_lang,
68: name,

Line 85: from per_abs_attendance_types_tl tl

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);
88:
89: