APPS.PER_ABS_BUS dependencies on HR_LOOKUPS

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 1769: -- If a row does not exist in per_abs_attendance_reason and hr_lookups for

1765: -- Post Success:
1766: -- If a row does exist; processing continues.
1767: --
1768: -- Post Failure:
1769: -- If a row does not exist in per_abs_attendance_reason and hr_lookups for
1770: -- a given reason id then an error will be raised and processing terminated.
1771: --
1772: -- Access Status:
1773: -- Internal Table Handler Use Only.

Line 1797: hr_lookups hrl

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
1801: and abr.name = hrl.lookup_code