APPS.HR_ORI_BUS dependencies on HR_LOOKUPS

Line 1433: FROM hr_lookups

1429: l_exists VARCHAR2(1) := 'N';
1430: --
1431: cursor csr_cls_valid IS
1432: SELECT 'Y'
1433: FROM hr_lookups
1434: WHERE lookup_type = 'ORG_CLASS'
1435: AND lookup_code = p_org_information1
1436: AND enabled_flag = 'Y'
1437: AND p_effective_date BETWEEN nvl(start_date_active,p_effective_date)

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

2111: -- column, ensure client_info is populated by calling a suitable
2112: -- ???_???_bus.set_security_group_id procedure, or add one of the following
2113: -- comments:
2114: -- "-- No business group context. HR_STANDARD_LOOKUPS used for validation."
2115: -- "-- CLIENT_INFO not set. No lookup validation or joins to HR_LOOKUPS."
2116: --
2117: -- Check unique business group name
2118: -- ================================
2119: chk_name(