4183: -- bug# 2351782
4184: -- Bugfix# 2835357, check if the source system is valid or not once.
4185: SELECT count(*)
4186: INTO l_source_system 4187: FROM as_lookups 4188: WHERE lookup_type = 'SOURCE_SYSTEM'
4189: AND lookup_code = p_source_system;
4190:
4191: -- SOLIN, bug 4494009