APPS.HR_ORI_BUS dependencies on HR_LOOKUPS

Line 1423: FROM hr_lookups

1419: l_exists VARCHAR2(1) := 'N';
1420: --
1421: cursor csr_cls_valid IS
1422: SELECT 'Y'
1423: FROM hr_lookups
1424: WHERE lookup_type = 'ORG_CLASS'
1425: AND lookup_code = p_org_information1
1426: AND enabled_flag = 'Y'
1427: AND p_effective_date BETWEEN nvl(start_date_active,p_effective_date)

Line 2105: -- "-- CLIENT_INFO not set. No lookup validation or joins to HR_LOOKUPS."

2101: -- column, ensure client_info is populated by calling a suitable
2102: -- ???_???_bus.set_security_group_id procedure, or add one of the following
2103: -- comments:
2104: -- "-- No business group context. HR_STANDARD_LOOKUPS used for validation."
2105: -- "-- CLIENT_INFO not set. No lookup validation or joins to HR_LOOKUPS."
2106: --
2107: -- Check unique business group name
2108: -- ================================
2109: chk_name(