APPS.WSH_MAP_LOCATION_REGION_PKG dependencies on WSH_DOC_SEQUENCE_CATEGORIES

Line 3138: l_token := 'WSH_DOC_SEQUENCE_CATEGORIES';

3134: END ;
3135:
3136:
3137: BEGIN
3138: l_token := 'WSH_DOC_SEQUENCE_CATEGORIES';
3139: IF l_debug_on THEN
3140: wsh_debug_sv.LOG(l_module_name, 'Validating records in table', l_token);
3141: END IF;
3142: v_delete_permitted := NULL;

Line 3145: FROM WSH_DOC_SEQUENCE_CATEGORIES WDO, WSH_LOCATIONS WSH

3141: END IF;
3142: v_delete_permitted := NULL;
3143: SELECT 'N'
3144: INTO v_delete_permitted
3145: FROM WSH_DOC_SEQUENCE_CATEGORIES WDO, WSH_LOCATIONS WSH
3146: WHERE WDO.LOCATION_ID = P_LOCATION_ID
3147: AND WSH.WSH_LOCATION_ID = WDO.LOCATION_ID
3148: AND WSH.LOCATION_SOURCE_CODE = 'HR'
3149: AND ROWNUM = 1;