APPS.PER_ABT_BUS dependencies on PER_ABSENCE_ATTENDANCE_TYPES

Line 33: , per_absence_attendance_types abb

29: --
30: cursor csr_leg_code is
31: select pbg.legislation_code
32: from per_business_groups_perf pbg
33: , per_absence_attendance_types abb
34: where abb.absence_attendance_type_id = p_absence_attendance_type_id
35: and pbg.business_group_id (+) = abb.business_group_id;
36: --
37: -- Declare local variables

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 176: from per_absence_attendance_types x

172: and abb.absence_attendance_type_id = abt.absence_attendance_type_id
173: and (abb.business_group_id is null
174: or (abb.business_group_id is not null and abb.business_group_id in
175: (select nvl(x.business_group_id,abb.business_group_id)
176: from per_absence_attendance_types x
177: where x.absence_attendance_type_id = p_absence_attendance_type_id)));
178: --
179: Begin
180: hr_utility.set_location('Entering:'||l_proc,10);

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