APPS.PER_ABS_BUS dependencies on PER_ABS_ATTENDANCE_REASONS

Line 1935: -- per_abs_attendance_reasons, also valid in hr_lookups

1931: -- ---------------------------------------------------------------------------
1932: --
1933: -- Description:
1934: -- Validates that an abs_attendance_reason_id exists in table
1935: -- per_abs_attendance_reasons, also valid in hr_lookups
1936: -- where lookup_type is 'ABSENCE_REASON' and enabled_flag is 'Y'
1937: -- and effective_date is between the active dates (if they are not null).
1938: --
1939: -- Pre-conditions:

Line 1983: from per_abs_attendance_reasons abr,

1979: l_business_group_id number;
1980: --
1981: cursor csr_valid_abs_reason is
1982: select null
1983: from per_abs_attendance_reasons abr,
1984: hr_lookups hrl
1985: where abr.business_group_id = p_business_group_id
1986: and abr.absence_attendance_type_id = p_absence_attendance_type_id
1987: and abr.abs_attendance_reason_id = p_abs_attendance_reason_id