eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_ABS_BUS dependencies on HR_LOOKUPS

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

1952: -- Post Success:
1953: -- If a row does exist; processing continues.
1954: --
1955: -- Post Failure:
1956: -- If a row does not exist in per_abs_attendance_reason and hr_lookups for
1957: -- a given reason id then an error will be raised and processing terminated.
1958: --
1959: -- Access Status:
1960: -- Internal Table Handler Use Only.

Line 1984: hr_lookups hrl

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