APPS.PER_ABS_BUS dependencies on PER_ABS_ATTENDANCE_REASONS

Line 1748: -- per_abs_attendance_reasons, also valid in hr_lookups

1744: -- ---------------------------------------------------------------------------
1745: --
1746: -- Description:
1747: -- Validates that an abs_attendance_reason_id exists in table
1748: -- per_abs_attendance_reasons, also valid in hr_lookups
1749: -- where lookup_type is 'ABSENCE_REASON' and enabled_flag is 'Y'
1750: -- and effective_date is between the active dates (if they are not null).
1751: --
1752: -- Pre-conditions:

Line 1796: from per_abs_attendance_reasons abr,

1792: l_business_group_id number;
1793: --
1794: cursor csr_valid_abs_reason is
1795: select null
1796: from per_abs_attendance_reasons abr,
1797: hr_lookups hrl
1798: where abr.business_group_id = p_business_group_id
1799: and abr.absence_attendance_type_id = p_absence_attendance_type_id
1800: and abr.abs_attendance_reason_id = p_abs_attendance_reason_id