APPS.BEN_ELR_BUS dependencies on PER_ABSENCE_ATTENDANCE_TYPES

Line 188: from per_absence_attendance_types abs

184: l_dummy varchar2(1);
185: --
186: cursor c1 is
187: select null
188: from per_absence_attendance_types abs
189: where abs.absence_attendance_type_id = p_absence_attendance_type_id
190: and abs.business_group_id = p_business_group_id;
191: --
192: Begin

Line 218: -- per_absence_attendance_types table.

214: --
215: close c1;
216: --
217: -- raise error as FK does not relate to PK in
218: -- per_absence_attendance_types table.
219: --
220: ben_elr_shd.constraint_error('BEN_ELIG_LOA_RSN_PRTE_F_FK2');
221: --
222: end if;