APPS.WSH_PURGE dependencies on WSH_LOOKUPS

Line 2206: l_src_meaning wsh_lookups.meaning%TYPE; --RTV changes

2202: l_empty_trip_count NUMBER;
2203: l_empty_del_count NUMBER;
2204: l_empty_lpn_count NUMBER;
2205: l_buff_size NUMBER;
2206: l_src_meaning wsh_lookups.meaning%TYPE; --RTV changes
2207: l_err varchar2(500);
2208:
2209: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'GENERATE_PURGE_REPORT';
2210:

Line 2360: FROM wsh_lookups

2356: */
2357:
2358: SELECT meaning
2359: INTO l_src_meaning
2360: FROM wsh_lookups
2361: WHERE lookup_code = p_source_system
2362: AND lookup_type in ('WSH_PURGE_SOURCE_SYSTEMS','SOURCE_SYSTEM')
2363: AND LOOKUP_CODE <> 'OKE'
2364: AND enabled_flag = 'Y'