APPS.PER_ABT_BUS dependencies on PER_ABS_ATTENDANCE_TYPES_TL

Line 168: from per_absence_attendance_types abb, per_abs_attendance_types_tl abt

164: -- p_rec value for the id is not set on insert
165: --
166: cursor csr_chk_unique_name is
167: select 1
168: from per_absence_attendance_types abb, per_abs_attendance_types_tl abt
169: where abt.absence_attendance_type_id <> p_absence_attendance_type_id
170: and abt.language = p_rec.language
171: and abt.name = p_rec.name
172: and abb.absence_attendance_type_id = abt.absence_attendance_type_id

Line 207: (p_associated_column1 => 'PER_ABS_ATTENDANCE_TYPES_TL.NAME'

203: hr_utility.set_location('Leaving:'||l_proc,70);
204: exception
205: when app_exception.application_exception then
206: if hr_multi_message.exception_add
207: (p_associated_column1 => 'PER_ABS_ATTENDANCE_TYPES_TL.NAME'
208: ) then
209: hr_utility.set_location('Leaving:'||l_proc,80);
210: raise;
211: end if;

Line 339: from per_absence_attendance_types abb, per_abs_attendance_types_tl abt

335: l_dummy number;
336: --
337: cursor csr_chk_unique_name is
338: select 1
339: from per_absence_attendance_types abb, per_abs_attendance_types_tl abt
340: where (p_absence_attendance_type_id is null
341: or p_absence_attendance_type_id <> abt.absence_attendance_type_id)
342: and abt.language = p_language
343: and abt.name = p_name